Overview
Brought to you by YData
Dataset statistics
| Number of variables | 54 |
|---|---|
| Number of observations | 84949 |
| Missing cells | 142785 |
| Missing cells (%) | 3.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 139.2 MiB |
| Average record size in memory | 1.7 KiB |
Variable types
| Numeric | 21 |
|---|---|
| Text | 13 |
| Categorical | 19 |
| DateTime | 1 |
booking_adult_count is highly overall correlated with booking_pax_count | High correlation |
booking_leg_count is highly overall correlated with booking_trip_type | High correlation |
booking_original_currency is highly overall correlated with preffered_language | High correlation |
booking_pax_count is highly overall correlated with booking_adult_count | High correlation |
booking_reservation_month is highly overall correlated with leg_departure_month | High correlation |
booking_segments_count is highly overall correlated with booking_trip_type | High correlation |
booking_trip_type is highly overall correlated with booking_leg_count and 1 other fields | High correlation |
coupon_cabin_class is highly overall correlated with coupon_rbd_code | High correlation |
coupon_miles is highly overall correlated with coupon_range and 1 other fields | High correlation |
coupon_number is highly overall correlated with leg_number | High correlation |
coupon_range is highly overall correlated with coupon_miles | High correlation |
coupon_rbd_code is highly overall correlated with coupon_cabin_class | High correlation |
graphic_design is highly overall correlated with top_1_section and 2 other fields | High correlation |
leg_departure_month is highly overall correlated with booking_reservation_month | High correlation |
leg_destination_country_code is highly overall correlated with coupon_miles and 1 other fields | High correlation |
leg_first_leg_flg is highly overall correlated with leg_last_leg_flg and 1 other fields | High correlation |
leg_hours_to_departure is highly overall correlated with leg_origin_country_code | High correlation |
leg_last_leg_flg is highly overall correlated with leg_first_leg_flg and 1 other fields | High correlation |
leg_number is highly overall correlated with coupon_number | High correlation |
leg_origin_country_code is highly overall correlated with leg_hours_to_departure and 1 other fields | High correlation |
leg_stopover_time_h is highly overall correlated with leg_first_leg_flg and 1 other fields | High correlation |
preffered_language is highly overall correlated with booking_original_currency and 2 other fields | High correlation |
top_1_section is highly overall correlated with graphic_design and 2 other fields | High correlation |
top_2_section is highly overall correlated with graphic_design and 1 other fields | High correlation |
top_3_section is highly overall correlated with graphic_design and 1 other fields | High correlation |
booking_infant_count is highly imbalanced (95.1%) | Imbalance |
booking_leg_count is highly imbalanced (56.5%) | Imbalance |
booking_payment_method is highly imbalanced (73.4%) | Imbalance |
booking_sales_channel is highly imbalanced (54.8%) | Imbalance |
coupon_cabin_class is highly imbalanced (88.6%) | Imbalance |
coupon_range is highly imbalanced (62.3%) | Imbalance |
booking_destination_airport_code has 5199 (6.1%) missing values | Missing |
booking_original_currency has 7318 (8.6%) missing values | Missing |
leg_destination_country_code has 65106 (76.6%) missing values | Missing |
leg_origin_country_code has 65079 (76.6%) missing values | Missing |
id has unique values | Unique |
booking_child_count has 81146 (95.5%) zeros | Zeros |
booking_window_w has 7291 (8.6%) zeros | Zeros |
leg_duration_h has 3115 (3.7%) zeros | Zeros |
top_3_section has 16945 (19.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-04-12 09:49:12.297520 |
|---|---|
| Analysis finished | 2025-04-12 09:50:45.717507 |
| Duration | 1 minute and 33.42 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
id
Real number (ℝ)
Unique 
| Distinct | 84949 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57911.408 |
| Minimum | 0 |
|---|---|
| Maximum | 116328 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5683.2 |
| Q1 | 28606 |
| median | 57711 |
| Q3 | 87172 |
| 95-th percentile | 110589.2 |
| Maximum | 116328 |
| Range | 116328 |
| Interquartile range (IQR) | 58566 |
Descriptive statistics
| Standard deviation | 33694.182 |
|---|---|
| Coefficient of variation (CV) | 0.58182288 |
| Kurtosis | -1.204811 |
| Mean | 57911.408 |
| Median Absolute Deviation (MAD) | 29280 |
| Skewness | 0.014588137 |
| Sum | 4.9195162 × 109 |
| Variance | 1.1352979 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 105529 | 1 | < 0.1% |
| 85092 | 1 | < 0.1% |
| 58605 | 1 | < 0.1% |
| 26759 | 1 | < 0.1% |
| 15674 | 1 | < 0.1% |
| 64692 | 1 | < 0.1% |
| 78039 | 1 | < 0.1% |
| 115584 | 1 | < 0.1% |
| 22480 | 1 | < 0.1% |
| 109814 | 1 | < 0.1% |
| Other values (84939) | 84939 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 13 | 1 | |
| 14 | 1 |
| Value | Count | Frequency (%) |
| 116328 | 1 | |
| 116327 | 1 | |
| 116326 | 1 | |
| 116325 | 1 | |
| 116324 | 1 | |
| 116320 | 1 | |
| 116319 | 1 | |
| 116317 | 1 | |
| 116314 | 1 | |
| 116313 | 1 |
booking_adult_count
Real number (ℝ)
High correlation 
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4624775 |
| Minimum | 0 |
|---|---|
| Maximum | 96 |
| Zeros | 34 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 96 |
| Range | 96 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.4794811 |
|---|---|
| Coefficient of variation (CV) | 1.0116266 |
| Kurtosis | 636.44277 |
| Mean | 1.4624775 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.30858 |
| Sum | 124236 |
| Variance | 2.1888643 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 59936 | |
| 2 | 19367 | 22.8% |
| 3 | 3038 | 3.6% |
| 4 | 1444 | 1.7% |
| 5 | 391 | 0.5% |
| 6 | 209 | 0.2% |
| 7 | 117 | 0.1% |
| 8 | 104 | 0.1% |
| 9 | 57 | 0.1% |
| 0 | 34 | < 0.1% |
| Other values (39) | 252 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 34 | < 0.1% |
| 1 | 59936 | |
| 2 | 19367 | 22.8% |
| 3 | 3038 | 3.6% |
| 4 | 1444 | 1.7% |
| 5 | 391 | 0.5% |
| 6 | 209 | 0.2% |
| 7 | 117 | 0.1% |
| 8 | 104 | 0.1% |
| 9 | 57 | 0.1% |
| Value | Count | Frequency (%) |
| 96 | 1 | < 0.1% |
| 92 | 1 | < 0.1% |
| 55 | 1 | < 0.1% |
| 53 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 49 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 45 | 3 | |
| 44 | 2 | |
| 43 | 2 |
booking_child_count
Real number (ℝ)
Zeros 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.057975962 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 81146 |
| Zeros (%) | 95.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.29031121 |
|---|---|
| Coefficient of variation (CV) | 5.007441 |
| Kurtosis | 39.393484 |
| Mean | 0.057975962 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.8444326 |
| Sum | 4925 |
| Variance | 0.0842806 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 81146 | |
| 1 | 2805 | 3.3% |
| 2 | 886 | 1.0% |
| 3 | 102 | 0.1% |
| 4 | 8 | < 0.1% |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 81146 | |
| 1 | 2805 | 3.3% |
| 2 | 886 | 1.0% |
| 3 | 102 | 0.1% |
| 4 | 8 | < 0.1% |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 2 | < 0.1% |
| 4 | 8 | < 0.1% |
| 3 | 102 | 0.1% |
| 2 | 886 | 1.0% |
| 1 | 2805 | 3.3% |
| 0 | 81146 |
booking_destination_airport_code
Text
Missing 
| Distinct | 88 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 5199 |
| Missing (%) | 6.1% |
| Memory size | 4.1 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | TBS |
|---|---|
| 2nd row | WAW |
| 3rd row | BEG |
| 4th row | BOM |
| 5th row | OTP |
| Value | Count | Frequency (%) |
| waw | 21676 | |
| lhr | 2424 | 3.0% |
| ams | 1941 | 2.4% |
| vno | 1857 | 2.3% |
| jfk | 1771 | 2.2% |
| ist | 1726 | 2.2% |
| krk | 1726 | 2.2% |
| ord | 1710 | 2.1% |
| cdg | 1541 | 1.9% |
| prg | 1489 | 1.9% |
| Other values (78) | 41889 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 44798 | |
| A | 32729 | |
| R | 17183 | 7.2% |
| O | 10174 | 4.3% |
| L | 10011 | 4.2% |
| T | 9441 | 3.9% |
| D | 9298 | 3.9% |
| C | 8940 | 3.7% |
| S | 8728 | 3.6% |
| N | 7938 | 3.3% |
| Other values (16) | 80010 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 239250 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 44798 | |
| A | 32729 | |
| R | 17183 | 7.2% |
| O | 10174 | 4.3% |
| L | 10011 | 4.2% |
| T | 9441 | 3.9% |
| D | 9298 | 3.9% |
| C | 8940 | 3.7% |
| S | 8728 | 3.6% |
| N | 7938 | 3.3% |
| Other values (16) | 80010 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 239250 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 44798 | |
| A | 32729 | |
| R | 17183 | 7.2% |
| O | 10174 | 4.3% |
| L | 10011 | 4.2% |
| T | 9441 | 3.9% |
| D | 9298 | 3.9% |
| C | 8940 | 3.7% |
| S | 8728 | 3.6% |
| N | 7938 | 3.3% |
| Other values (16) | 80010 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 239250 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 44798 | |
| A | 32729 | |
| R | 17183 | 7.2% |
| O | 10174 | 4.3% |
| L | 10011 | 4.2% |
| T | 9441 | 3.9% |
| D | 9298 | 3.9% |
| C | 8940 | 3.7% |
| S | 8728 | 3.6% |
| N | 7938 | 3.3% |
| Other values (16) | 80010 |
booking_id
Real number (ℝ)
| Distinct | 81734 |
|---|---|
| Distinct (%) | 96.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5503856 |
| Minimum | 1000143 |
|---|---|
| Maximum | 9999956 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1000143 |
|---|---|
| 5-th percentile | 1459341.4 |
| Q1 | 3251179 |
| median | 5503001 |
| Q3 | 7740747 |
| 95-th percentile | 9557143.2 |
| Maximum | 9999956 |
| Range | 8999813 |
| Interquartile range (IQR) | 4489568 |
Descriptive statistics
| Standard deviation | 2593980.4 |
|---|---|
| Coefficient of variation (CV) | 0.47130237 |
| Kurtosis | -1.1946804 |
| Mean | 5503856 |
| Median Absolute Deviation (MAD) | 2244662 |
| Skewness | -0.00042049661 |
| Sum | 4.6754706 × 1011 |
| Variance | 6.7287343 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5567317 | 11 | < 0.1% |
| 7494700 | 7 | < 0.1% |
| 5709675 | 6 | < 0.1% |
| 2434140 | 5 | < 0.1% |
| 2198660 | 5 | < 0.1% |
| 4075744 | 5 | < 0.1% |
| 2057360 | 5 | < 0.1% |
| 1817985 | 5 | < 0.1% |
| 5837515 | 4 | < 0.1% |
| 5534177 | 4 | < 0.1% |
| Other values (81724) | 84892 |
| Value | Count | Frequency (%) |
| 1000143 | 1 | |
| 1000588 | 1 | |
| 1000605 | 2 | |
| 1000843 | 1 | |
| 1000848 | 1 | |
| 1000860 | 2 | |
| 1000899 | 1 | |
| 1001098 | 1 | |
| 1001137 | 1 | |
| 1001169 | 1 |
| Value | Count | Frequency (%) |
| 9999956 | 1 | |
| 9999704 | 1 | |
| 9999596 | 1 | |
| 9999457 | 1 | |
| 9999335 | 1 | |
| 9999264 | 1 | |
| 9999220 | 1 | |
| 9999172 | 1 | |
| 9999053 | 1 | |
| 9999041 | 1 |
booking_infant_count
Categorical
Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 0 | |
|---|---|
| 1 | 1022 |
| 2 | 19 |
| 4 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 83907 | |
| 1 | 1022 | 1.2% |
| 2 | 19 | < 0.1% |
| 4 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 83907 | |
| 1 | 1022 | 1.2% |
| 2 | 19 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 83907 | |
| 1 | 1022 | 1.2% |
| 2 | 19 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 83907 | |
| 1 | 1022 | 1.2% |
| 2 | 19 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 83907 | |
| 1 | 1022 | 1.2% |
| 2 | 19 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 83907 | |
| 1 | 1022 | 1.2% |
| 2 | 19 | < 0.1% |
| 4 | 1 | < 0.1% |
booking_leg_count
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 2 | |
|---|---|
| 1 | |
| 3 | 252 |
| 4 | 10 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 61847 | |
| 1 | 22840 | 26.9% |
| 3 | 252 | 0.3% |
| 4 | 10 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 61847 | |
| 1 | 22840 | 26.9% |
| 3 | 252 | 0.3% |
| 4 | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 61847 | |
| 1 | 22840 | 26.9% |
| 3 | 252 | 0.3% |
| 4 | 10 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 61847 | |
| 1 | 22840 | 26.9% |
| 3 | 252 | 0.3% |
| 4 | 10 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 61847 | |
| 1 | 22840 | 26.9% |
| 3 | 252 | 0.3% |
| 4 | 10 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 61847 | |
| 1 | 22840 | 26.9% |
| 3 | 252 | 0.3% |
| 4 | 10 | < 0.1% |
booking_market
Text
| Distinct | 72 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GE |
|---|---|
| 2nd row | US |
| 3rd row | PL |
| 4th row | SE |
| 5th row | PL |
| Value | Count | Frequency (%) |
| pl | 30864 | |
| us | 10015 | 11.8% |
| se | 9310 | 11.0% |
| gb | 3410 | 4.0% |
| de | 3067 | 3.6% |
| ca | 2491 | 2.9% |
| lt | 2349 | 2.8% |
| nl | 1700 | 2.0% |
| ee | 1625 | 1.9% |
| dk | 1605 | 1.9% |
| Other values (62) | 18513 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 36334 | |
| P | 31131 | |
| S | 21680 | |
| E | 18932 | |
| U | 11701 | 6.9% |
| B | 5125 | 3.0% |
| D | 4999 | 2.9% |
| C | 4902 | 2.9% |
| R | 4675 | 2.8% |
| G | 4440 | 2.6% |
| Other values (15) | 25979 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 169898 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 36334 | |
| P | 31131 | |
| S | 21680 | |
| E | 18932 | |
| U | 11701 | 6.9% |
| B | 5125 | 3.0% |
| D | 4999 | 2.9% |
| C | 4902 | 2.9% |
| R | 4675 | 2.8% |
| G | 4440 | 2.6% |
| Other values (15) | 25979 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 169898 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 36334 | |
| P | 31131 | |
| S | 21680 | |
| E | 18932 | |
| U | 11701 | 6.9% |
| B | 5125 | 3.0% |
| D | 4999 | 2.9% |
| C | 4902 | 2.9% |
| R | 4675 | 2.8% |
| G | 4440 | 2.6% |
| Other values (15) | 25979 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 169898 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 36334 | |
| P | 31131 | |
| S | 21680 | |
| E | 18932 | |
| U | 11701 | 6.9% |
| B | 5125 | 3.0% |
| D | 4999 | 2.9% |
| C | 4902 | 2.9% |
| R | 4675 | 2.8% |
| G | 4440 | 2.6% |
| Other values (15) | 25979 |
| Distinct | 86 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WAW |
|---|---|
| 2nd row | EWR |
| 3rd row | SZZ |
| 4th row | WAW |
| 5th row | OSL |
| Value | Count | Frequency (%) |
| waw | 32282 | |
| vno | 2980 | 3.5% |
| lhr | 2669 | 3.1% |
| ord | 2179 | 2.6% |
| jfk | 1916 | 2.3% |
| krk | 1852 | 2.2% |
| yyz | 1852 | 2.2% |
| ams | 1822 | 2.1% |
| tll | 1744 | 2.1% |
| otp | 1643 | 1.9% |
| Other values (76) | 34010 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 66876 | |
| A | 40456 | |
| R | 18368 | 7.2% |
| O | 12353 | 4.8% |
| L | 11155 | 4.4% |
| D | 7611 | 3.0% |
| S | 7424 | 2.9% |
| N | 7184 | 2.8% |
| T | 7137 | 2.8% |
| K | 6454 | 2.5% |
| Other values (16) | 69829 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 66876 | |
| A | 40456 | |
| R | 18368 | 7.2% |
| O | 12353 | 4.8% |
| L | 11155 | 4.4% |
| D | 7611 | 3.0% |
| S | 7424 | 2.9% |
| N | 7184 | 2.8% |
| T | 7137 | 2.8% |
| K | 6454 | 2.5% |
| Other values (16) | 69829 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 66876 | |
| A | 40456 | |
| R | 18368 | 7.2% |
| O | 12353 | 4.8% |
| L | 11155 | 4.4% |
| D | 7611 | 3.0% |
| S | 7424 | 2.9% |
| N | 7184 | 2.8% |
| T | 7137 | 2.8% |
| K | 6454 | 2.5% |
| Other values (16) | 69829 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 66876 | |
| A | 40456 | |
| R | 18368 | 7.2% |
| O | 12353 | 4.8% |
| L | 11155 | 4.4% |
| D | 7611 | 3.0% |
| S | 7424 | 2.9% |
| N | 7184 | 2.8% |
| T | 7137 | 2.8% |
| K | 6454 | 2.5% |
| Other values (16) | 69829 |
booking_original_currency
Categorical
High correlation  Missing 
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 7318 |
| Missing (%) | 8.6% |
| Memory size | 4.2 MiB |
| PLN | |
|---|---|
| EUR | |
| USD | |
| SEK | |
| GBP | |
| Other values (37) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GEL |
|---|---|
| 2nd row | USD |
| 3rd row | PLN |
| 4th row | PLN |
| 5th row | PLN |
Common Values
| Value | Count | Frequency (%) |
| PLN | 28679 | |
| EUR | 16648 | |
| USD | 9916 | 11.7% |
| SEK | 8352 | 9.8% |
| GBP | 3105 | 3.7% |
| CAD | 2297 | 2.7% |
| DKK | 1477 | 1.7% |
| NOK | 1150 | 1.4% |
| CHF | 1069 | 1.3% |
| CZK | 991 | 1.2% |
| Other values (32) | 3947 | 4.6% |
| (Missing) | 7318 | 8.6% |
Length
| Value | Count | Frequency (%) |
| pln | 28679 | |
| eur | 16648 | |
| usd | 9916 | 12.8% |
| sek | 8352 | 10.8% |
| gbp | 3105 | 4.0% |
| cad | 2297 | 3.0% |
| dkk | 1477 | 1.9% |
| nok | 1150 | 1.5% |
| chf | 1069 | 1.4% |
| czk | 991 | 1.3% |
| Other values (32) | 3947 | 5.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 32072 | |
| N | 31084 | |
| L | 29029 | |
| U | 27189 | |
| E | 25503 | |
| S | 18647 | |
| R | 18535 | |
| K | 14117 | |
| D | 14027 | |
| C | 4380 | 1.9% |
| Other values (15) | 18310 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 232893 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 32072 | |
| N | 31084 | |
| L | 29029 | |
| U | 27189 | |
| E | 25503 | |
| S | 18647 | |
| R | 18535 | |
| K | 14117 | |
| D | 14027 | |
| C | 4380 | 1.9% |
| Other values (15) | 18310 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 232893 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 32072 | |
| N | 31084 | |
| L | 29029 | |
| U | 27189 | |
| E | 25503 | |
| S | 18647 | |
| R | 18535 | |
| K | 14117 | |
| D | 14027 | |
| C | 4380 | 1.9% |
| Other values (15) | 18310 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 232893 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 32072 | |
| N | 31084 | |
| L | 29029 | |
| U | 27189 | |
| E | 25503 | |
| S | 18647 | |
| R | 18535 | |
| K | 14117 | |
| D | 14027 | |
| C | 4380 | 1.9% |
| Other values (15) | 18310 |
booking_pax_count
Real number (ℝ)
High correlation 
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5329786 |
| Minimum | 1 |
|---|---|
| Maximum | 96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 96 |
| Range | 95 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.53779 |
|---|---|
| Coefficient of variation (CV) | 1.0031386 |
| Kurtosis | 555.78944 |
| Mean | 1.5329786 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.521934 |
| Sum | 130225 |
| Variance | 2.364798 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58414 | |
| 2 | 18403 | 21.7% |
| 3 | 4247 | 5.0% |
| 4 | 2410 | 2.8% |
| 5 | 611 | 0.7% |
| 6 | 284 | 0.3% |
| 7 | 142 | 0.2% |
| 8 | 115 | 0.1% |
| 9 | 69 | 0.1% |
| 10 | 27 | < 0.1% |
| Other values (39) | 227 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 58414 | |
| 2 | 18403 | 21.7% |
| 3 | 4247 | 5.0% |
| 4 | 2410 | 2.8% |
| 5 | 611 | 0.7% |
| 6 | 284 | 0.3% |
| 7 | 142 | 0.2% |
| 8 | 115 | 0.1% |
| 9 | 69 | 0.1% |
| 10 | 27 | < 0.1% |
| Value | Count | Frequency (%) |
| 96 | 1 | < 0.1% |
| 94 | 1 | < 0.1% |
| 55 | 1 | < 0.1% |
| 53 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 49 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 45 | 3 | |
| 44 | 2 | |
| 43 | 2 |
booking_payment_method
Categorical
Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 MiB |
| 95582540167d4ebb9497a7031f046757 | |
|---|---|
| 1bb2b25a099d4a438425d276203a0c2c | 7087 |
| e248b21630a9467cbdff5232836930a3 | 1364 |
| 236d48d3e6ce425599faccbf2f0a06f2 | 7 |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 95582540167d4ebb9497a7031f046757 |
|---|---|
| 2nd row | 95582540167d4ebb9497a7031f046757 |
| 3rd row | 1bb2b25a099d4a438425d276203a0c2c |
| 4th row | 1bb2b25a099d4a438425d276203a0c2c |
| 5th row | 95582540167d4ebb9497a7031f046757 |
Common Values
| Value | Count | Frequency (%) |
| 95582540167d4ebb9497a7031f046757 | 76491 | |
| 1bb2b25a099d4a438425d276203a0c2c | 7087 | 8.3% |
| e248b21630a9467cbdff5232836930a3 | 1364 | 1.6% |
| 236d48d3e6ce425599faccbf2f0a06f2 | 7 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 95582540167d4ebb9497a7031f046757 | 76491 | |
| 1bb2b25a099d4a438425d276203a0c2c | 7087 | 8.3% |
| e248b21630a9467cbdff5232836930a3 | 1364 | 1.6% |
| 236d48d3e6ce425599faccbf2f0a06f2 | 7 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 390906 | |
| 4 | 329967 | |
| 5 | 321516 | |
| 0 | 253476 | |
| 9 | 246389 | |
| b | 176978 | 6.5% |
| 6 | 164182 | 6.0% |
| 1 | 161433 | 5.9% |
| 2 | 124497 | 4.6% |
| a | 100494 | 3.7% |
| Other values (6) | 448530 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7 | 390906 | |
| 4 | 329967 | |
| 5 | 321516 | |
| 0 | 253476 | |
| 9 | 246389 | |
| b | 176978 | 6.5% |
| 6 | 164182 | 6.0% |
| 1 | 161433 | 5.9% |
| 2 | 124497 | 4.6% |
| a | 100494 | 3.7% |
| Other values (6) | 448530 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7 | 390906 | |
| 4 | 329967 | |
| 5 | 321516 | |
| 0 | 253476 | |
| 9 | 246389 | |
| b | 176978 | 6.5% |
| 6 | 164182 | 6.0% |
| 1 | 161433 | 5.9% |
| 2 | 124497 | 4.6% |
| a | 100494 | 3.7% |
| Other values (6) | 448530 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7 | 390906 | |
| 4 | 329967 | |
| 5 | 321516 | |
| 0 | 253476 | |
| 9 | 246389 | |
| b | 176978 | 6.5% |
| 6 | 164182 | 6.0% |
| 1 | 161433 | 5.9% |
| 2 | 124497 | 4.6% |
| a | 100494 | 3.7% |
| Other values (6) | 448530 |
booking_reservation_month
Real number (ℝ)
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6554756 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 7 |
| median | 9 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.1448372 |
|---|---|
| Coefficient of variation (CV) | 0.41079579 |
| Kurtosis | -0.13013452 |
| Mean | 7.6554756 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.94006014 |
| Sum | 650325 |
| Variance | 9.890001 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 17694 | |
| 8 | 14115 | |
| 10 | 13381 | |
| 1 | 7670 | |
| 7 | 7363 | |
| 11 | 7118 | |
| 12 | 4786 | 5.6% |
| 2 | 4612 | 5.4% |
| 6 | 3266 | 3.8% |
| 5 | 2139 | 2.5% |
| Other values (2) | 2805 | 3.3% |
| Value | Count | Frequency (%) |
| 1 | 7670 | |
| 2 | 4612 | 5.4% |
| 3 | 1327 | 1.6% |
| 4 | 1478 | 1.7% |
| 5 | 2139 | 2.5% |
| 6 | 3266 | 3.8% |
| 7 | 7363 | |
| 8 | 14115 | |
| 9 | 17694 | |
| 10 | 13381 |
| Value | Count | Frequency (%) |
| 12 | 4786 | 5.6% |
| 11 | 7118 | |
| 10 | 13381 | |
| 9 | 17694 | |
| 8 | 14115 | |
| 7 | 7363 | |
| 6 | 3266 | 3.8% |
| 5 | 2139 | 2.5% |
| 4 | 1478 | 1.7% |
| 3 | 1327 | 1.6% |
booking_sales_channel
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| website | |
|---|---|
| agents | |
| call_center | 1088 |
| aiport_agents | 644 |
| internal_agents | 141 |
Length
| Max length | 15 |
|---|---|
| Median length | 7 |
| Mean length | 6.8113927 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | website |
|---|---|
| 2nd row | website |
| 3rd row | website |
| 4th row | agents |
| 5th row | agents |
Common Values
| Value | Count | Frequency (%) |
| website | 57710 | |
| agents | 25366 | |
| call_center | 1088 | 1.3% |
| aiport_agents | 644 | 0.8% |
| internal_agents | 141 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| website | 57710 | |
| agents | 25366 | |
| call_center | 1088 | 1.3% |
| aiport_agents | 644 | 0.8% |
| internal_agents | 141 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 143888 | |
| t | 85734 | |
| s | 83861 | |
| i | 58495 | |
| w | 57710 | |
| b | 57710 | |
| a | 28024 | 4.8% |
| n | 27521 | 4.8% |
| g | 26151 | 4.5% |
| l | 2317 | 0.4% |
| Other values (5) | 7210 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 578621 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 143888 | |
| t | 85734 | |
| s | 83861 | |
| i | 58495 | |
| w | 57710 | |
| b | 57710 | |
| a | 28024 | 4.8% |
| n | 27521 | 4.8% |
| g | 26151 | 4.5% |
| l | 2317 | 0.4% |
| Other values (5) | 7210 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 578621 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 143888 | |
| t | 85734 | |
| s | 83861 | |
| i | 58495 | |
| w | 57710 | |
| b | 57710 | |
| a | 28024 | 4.8% |
| n | 27521 | 4.8% |
| g | 26151 | 4.5% |
| l | 2317 | 0.4% |
| Other values (5) | 7210 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 578621 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 143888 | |
| t | 85734 | |
| s | 83861 | |
| i | 58495 | |
| w | 57710 | |
| b | 57710 | |
| a | 28024 | 4.8% |
| n | 27521 | 4.8% |
| g | 26151 | 4.5% |
| l | 2317 | 0.4% |
| Other values (5) | 7210 | 1.2% |
booking_segments_count
Real number (ℝ)
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2488905 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.95216071 |
|---|---|
| Coefficient of variation (CV) | 0.42339132 |
| Kurtosis | -0.23977367 |
| Mean | 2.2488905 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.84027966 |
| Sum | 191041 |
| Variance | 0.90661002 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 51996 | |
| 4 | 16268 | 19.2% |
| 1 | 14101 | 16.6% |
| 3 | 2526 | 3.0% |
| 5 | 50 | 0.1% |
| 6 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 14101 | 16.6% |
| 2 | 51996 | |
| 3 | 2526 | 3.0% |
| 4 | 16268 | 19.2% |
| 5 | 50 | 0.1% |
| 6 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 8 | < 0.1% |
| 5 | 50 | 0.1% |
| 4 | 16268 | 19.2% |
| 3 | 2526 | 3.0% |
| 2 | 51996 | |
| 1 | 14101 | 16.6% |
booking_trip_type
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| RT | |
|---|---|
| OW | |
| MC | 5199 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RT |
|---|---|
| 2nd row | RT |
| 3rd row | RT |
| 4th row | OW |
| 5th row | RT |
Common Values
| Value | Count | Frequency (%) |
| RT | 58787 | |
| OW | 20963 | 24.7% |
| MC | 5199 | 6.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| rt | 58787 | |
| ow | 20963 | 24.7% |
| mc | 5199 | 6.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 58787 | |
| T | 58787 | |
| O | 20963 | 12.3% |
| W | 20963 | 12.3% |
| M | 5199 | 3.1% |
| C | 5199 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 169898 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 58787 | |
| T | 58787 | |
| O | 20963 | 12.3% |
| W | 20963 | 12.3% |
| M | 5199 | 3.1% |
| C | 5199 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 169898 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 58787 | |
| T | 58787 | |
| O | 20963 | 12.3% |
| W | 20963 | 12.3% |
| M | 5199 | 3.1% |
| C | 5199 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 169898 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 58787 | |
| T | 58787 | |
| O | 20963 | 12.3% |
| W | 20963 | 12.3% |
| M | 5199 | 3.1% |
| C | 5199 | 3.1% |
booking_window_w
Real number (ℝ)
Zeros 
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.915667 |
| Minimum | 0 |
|---|---|
| Maximum | 53 |
| Zeros | 7291 |
| Zeros (%) | 8.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 4 |
| Q3 | 7 |
| 95-th percentile | 20 |
| Maximum | 53 |
| Range | 53 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.9075653 |
|---|---|
| Coefficient of variation (CV) | 1.1676731 |
| Kurtosis | 8.1100139 |
| Mean | 5.915667 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 2.5357693 |
| Sum | 502530 |
| Variance | 47.714459 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 12756 | |
| 2 | 11212 | |
| 3 | 9535 | |
| 4 | 7918 | |
| 0 | 7291 | |
| 5 | 6175 | |
| 6 | 5102 | 6.0% |
| 7 | 4012 | 4.7% |
| 8 | 3370 | 4.0% |
| 9 | 2490 | 2.9% |
| Other values (43) | 15088 |
| Value | Count | Frequency (%) |
| 0 | 7291 | |
| 1 | 12756 | |
| 2 | 11212 | |
| 3 | 9535 | |
| 4 | 7918 | |
| 5 | 6175 | |
| 6 | 5102 | 6.0% |
| 7 | 4012 | 4.7% |
| 8 | 3370 | 4.0% |
| 9 | 2490 | 2.9% |
| Value | Count | Frequency (%) |
| 53 | 2 | < 0.1% |
| 51 | 5 | < 0.1% |
| 50 | 15 | < 0.1% |
| 49 | 42 | |
| 48 | 44 | |
| 47 | 31 | |
| 46 | 45 | |
| 45 | 22 | |
| 44 | 28 | |
| 43 | 34 |
coupon_cabin_class
Categorical
High correlation  Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.5 MiB |
| economy | |
|---|---|
| premium | 1301 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | economy |
|---|---|
| 2nd row | economy |
| 3rd row | economy |
| 4th row | economy |
| 5th row | economy |
Common Values
| Value | Count | Frequency (%) |
| economy | 83648 | |
| premium | 1301 | 1.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| economy | 83648 | |
| premium | 1301 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 167296 | |
| m | 86250 | |
| e | 84949 | |
| c | 83648 | |
| n | 83648 | |
| y | 83648 | |
| p | 1301 | 0.2% |
| r | 1301 | 0.2% |
| i | 1301 | 0.2% |
| u | 1301 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 594643 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 167296 | |
| m | 86250 | |
| e | 84949 | |
| c | 83648 | |
| n | 83648 | |
| y | 83648 | |
| p | 1301 | 0.2% |
| r | 1301 | 0.2% |
| i | 1301 | 0.2% |
| u | 1301 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 594643 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 167296 | |
| m | 86250 | |
| e | 84949 | |
| c | 83648 | |
| n | 83648 | |
| y | 83648 | |
| p | 1301 | 0.2% |
| r | 1301 | 0.2% |
| i | 1301 | 0.2% |
| u | 1301 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 594643 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 167296 | |
| m | 86250 | |
| e | 84949 | |
| c | 83648 | |
| n | 83648 | |
| y | 83648 | |
| p | 1301 | 0.2% |
| r | 1301 | 0.2% |
| i | 1301 | 0.2% |
| u | 1301 | 0.2% |
| Distinct | 82 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | WAW |
|---|---|
| 2nd row | EWR |
| 3rd row | WAW |
| 4th row | BOM |
| 5th row | WAW |
| Value | Count | Frequency (%) |
| waw | 40154 | |
| lhr | 2429 | 2.9% |
| ord | 1934 | 2.3% |
| jfk | 1857 | 2.2% |
| ams | 1806 | 2.1% |
| vno | 1589 | 1.9% |
| yyz | 1480 | 1.7% |
| bru | 1220 | 1.4% |
| cdg | 1168 | 1.4% |
| otp | 1120 | 1.3% |
| Other values (72) | 30192 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 81332 | |
| A | 48754 | |
| R | 13997 | 5.5% |
| L | 8562 | 3.4% |
| O | 8102 | 3.2% |
| D | 7134 | 2.8% |
| C | 6734 | 2.6% |
| S | 6724 | 2.6% |
| T | 6259 | 2.5% |
| H | 5687 | 2.2% |
| Other values (16) | 61562 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 81332 | |
| A | 48754 | |
| R | 13997 | 5.5% |
| L | 8562 | 3.4% |
| O | 8102 | 3.2% |
| D | 7134 | 2.8% |
| C | 6734 | 2.6% |
| S | 6724 | 2.6% |
| T | 6259 | 2.5% |
| H | 5687 | 2.2% |
| Other values (16) | 61562 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 81332 | |
| A | 48754 | |
| R | 13997 | 5.5% |
| L | 8562 | 3.4% |
| O | 8102 | 3.2% |
| D | 7134 | 2.8% |
| C | 6734 | 2.6% |
| S | 6724 | 2.6% |
| T | 6259 | 2.5% |
| H | 5687 | 2.2% |
| Other values (16) | 61562 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 81332 | |
| A | 48754 | |
| R | 13997 | 5.5% |
| L | 8562 | 3.4% |
| O | 8102 | 3.2% |
| D | 7134 | 2.8% |
| C | 6734 | 2.6% |
| S | 6724 | 2.6% |
| T | 6259 | 2.5% |
| H | 5687 | 2.2% |
| Other values (16) | 61562 |
| Distinct | 4571 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 1412 ? |
|---|---|
| Unique (%) | 1.7% |
Sample
| 1st row | ee702af56c9f42c49677ede02047afcd |
|---|---|
| 2nd row | 64e30cc1470248f6896a74d5774954b8 |
| 3rd row | 76c8fafae85c47e0849a2b85b23dce08 |
| 4th row | 9915e38b5cf247588f6f4ae680b53f5e |
| 5th row | 0b93a67a450640c19f68cd8e77464ffa |
| Value | Count | Frequency (%) |
| d576b543eb25443ba0540b652e0d31cb | 1384 | 1.6% |
| b5495dec57b448b1a7448671d1da2275 | 1038 | 1.2% |
| 382dd7483da444d2841eb36023ee0358 | 880 | 1.0% |
| e48ca0799a804a5ba3b361447ad4d602 | 792 | 0.9% |
| 4dd0a4d3f47c4a9b966440cc2277b291 | 791 | 0.9% |
| 1ff1ed3c2acd4cea9c10b09878cd63fb | 682 | 0.8% |
| 99a5ac38c0fb495fa74a1a803fca8435 | 674 | 0.8% |
| ee702af56c9f42c49677ede02047afcd | 655 | 0.8% |
| f484b44923e0489eb8582caf5c0b2978 | 624 | 0.7% |
| 82213c96be824c9ea6f47d5ae8776bac | 618 | 0.7% |
| Other values (4561) | 76811 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 257726 | 9.5% |
| 8 | 182730 | 6.7% |
| b | 178570 | 6.6% |
| a | 176546 | 6.5% |
| 9 | 173358 | 6.4% |
| 3 | 165267 | 6.1% |
| 7 | 163434 | 6.0% |
| c | 163140 | 6.0% |
| 5 | 163003 | 6.0% |
| d | 162461 | 6.0% |
| Other values (6) | 932133 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 257726 | 9.5% |
| 8 | 182730 | 6.7% |
| b | 178570 | 6.6% |
| a | 176546 | 6.5% |
| 9 | 173358 | 6.4% |
| 3 | 165267 | 6.1% |
| 7 | 163434 | 6.0% |
| c | 163140 | 6.0% |
| 5 | 163003 | 6.0% |
| d | 162461 | 6.0% |
| Other values (6) | 932133 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 257726 | 9.5% |
| 8 | 182730 | 6.7% |
| b | 178570 | 6.6% |
| a | 176546 | 6.5% |
| 9 | 173358 | 6.4% |
| 3 | 165267 | 6.1% |
| 7 | 163434 | 6.0% |
| c | 163140 | 6.0% |
| 5 | 163003 | 6.0% |
| d | 162461 | 6.0% |
| Other values (6) | 932133 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 257726 | 9.5% |
| 8 | 182730 | 6.7% |
| b | 178570 | 6.6% |
| a | 176546 | 6.5% |
| 9 | 173358 | 6.4% |
| 3 | 165267 | 6.1% |
| 7 | 163434 | 6.0% |
| c | 163140 | 6.0% |
| 5 | 163003 | 6.0% |
| d | 162461 | 6.0% |
| Other values (6) | 932133 |
coupon_marketing_flight_number
Real number (ℝ)
| Distinct | 378 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5308328.6 |
| Minimum | 1009781 |
|---|---|
| Maximum | 9989525 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1009781 |
|---|---|
| 5-th percentile | 1327210 |
| Q1 | 3218088 |
| median | 5296004 |
| Q3 | 7621582 |
| 95-th percentile | 9342807 |
| Maximum | 9989525 |
| Range | 8979744 |
| Interquartile range (IQR) | 4403494 |
Descriptive statistics
| Standard deviation | 2544544.6 |
|---|---|
| Coefficient of variation (CV) | 0.47934948 |
| Kurtosis | -1.1807325 |
| Mean | 5308328.6 |
| Median Absolute Deviation (MAD) | 2186885 |
| Skewness | 0.01907752 |
| Sum | 4.5093721 × 1011 |
| Variance | 6.4747071 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1327210 | 1374 | 1.6% |
| 2609995 | 1201 | 1.4% |
| 7648128 | 1197 | 1.4% |
| 1487938 | 1030 | 1.2% |
| 5609032 | 999 | 1.2% |
| 4286531 | 961 | 1.1% |
| 3297471 | 921 | 1.1% |
| 7127217 | 887 | 1.0% |
| 4547752 | 798 | 0.9% |
| 1299755 | 795 | 0.9% |
| Other values (368) | 74786 |
| Value | Count | Frequency (%) |
| 1009781 | 65 | 0.1% |
| 1156936 | 473 | |
| 1158981 | 10 | < 0.1% |
| 1160696 | 157 | 0.2% |
| 1208037 | 85 | 0.1% |
| 1236303 | 188 | 0.2% |
| 1252531 | 316 | |
| 1254679 | 239 | |
| 1265721 | 152 | 0.2% |
| 1271872 | 388 |
| Value | Count | Frequency (%) |
| 9989525 | 273 | |
| 9959105 | 253 | |
| 9951897 | 95 | 0.1% |
| 9950251 | 248 | |
| 9949418 | 421 | |
| 9938466 | 106 | 0.1% |
| 9903518 | 1 | < 0.1% |
| 9868778 | 116 | 0.1% |
| 9850913 | 66 | 0.1% |
| 9675329 | 408 |
coupon_miles
Real number (ℝ)
High correlation 
| Distinct | 83 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1545.8341 |
| Minimum | -9999 |
|---|---|
| Maximum | 6003 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 132 |
| Negative (%) | 0.2% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 316 |
| Q1 | 531 |
| median | 714 |
| Q3 | 1588 |
| 95-th percentile | 4801 |
| Maximum | 6003 |
| Range | 16002 |
| Interquartile range (IQR) | 1057 |
Descriptive statistics
| Standard deviation | 1708.4085 |
|---|---|
| Coefficient of variation (CV) | 1.1051694 |
| Kurtosis | 3.0896876 |
| Mean | 1545.8341 |
| Median Absolute Deviation (MAD) | 232 |
| Skewness | 0.77299674 |
| Sum | 1.3131706 × 108 |
| Variance | 2918659.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 912 | 4743 | 5.6% |
| 4255 | 3409 | 4.0% |
| 685 | 3336 | 3.9% |
| 4309 | 2736 | 3.2% |
| 4673 | 2666 | 3.1% |
| 246 | 2549 | 3.0% |
| 712 | 2416 | 2.8% |
| 574 | 2271 | 2.7% |
| 835 | 2207 | 2.6% |
| 323 | 2169 | 2.6% |
| Other values (73) | 56447 |
| Value | Count | Frequency (%) |
| -9999 | 132 | 0.2% |
| 211 | 131 | 0.2% |
| 242 | 311 | 0.4% |
| 246 | 2549 | |
| 316 | 1146 | |
| 323 | 2169 | |
| 334 | 1377 | |
| 341 | 897 | 1.1% |
| 350 | 1109 | |
| 356 | 116 | 0.1% |
| Value | Count | Frequency (%) |
| 6003 | 1392 | |
| 5353 | 1118 | |
| 5276 | 1230 | |
| 5056 | 309 | 0.4% |
| 4985 | 164 | 0.2% |
| 4801 | 881 | 1.0% |
| 4726 | 899 | 1.1% |
| 4673 | 2666 | |
| 4381 | 188 | 0.2% |
| 4315 | 112 | 0.1% |
coupon_number
Real number (ℝ)
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6027734 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.81292754 |
|---|---|
| Coefficient of variation (CV) | 0.50720054 |
| Kurtosis | 1.798903 |
| Mean | 1.6027734 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.4466719 |
| Sum | 136154 |
| Variance | 0.66085119 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 47195 | |
| 2 | 28624 | |
| 3 | 4921 | 5.8% |
| 4 | 4112 | 4.8% |
| 5 | 82 | 0.1% |
| 6 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 47195 | |
| 2 | 28624 | |
| 3 | 4921 | 5.8% |
| 4 | 4112 | 4.8% |
| 5 | 82 | 0.1% |
| 6 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 15 | < 0.1% |
| 5 | 82 | 0.1% |
| 4 | 4112 | 4.8% |
| 3 | 4921 | 5.8% |
| 2 | 28624 | |
| 1 | 47195 |
| Distinct | 80 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TBS |
|---|---|
| 2nd row | WAW |
| 3rd row | BEG |
| 4th row | WAW |
| 5th row | OSL |
| Value | Count | Frequency (%) |
| waw | 41416 | |
| lhr | 2314 | 2.7% |
| vno | 1692 | 2.0% |
| ord | 1634 | 1.9% |
| jfk | 1558 | 1.8% |
| ams | 1530 | 1.8% |
| yyz | 1264 | 1.5% |
| bru | 1196 | 1.4% |
| otp | 1152 | 1.4% |
| prg | 1084 | 1.3% |
| Other values (70) | 30109 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 83753 | |
| A | 49490 | |
| R | 13642 | 5.4% |
| L | 8637 | 3.4% |
| O | 8211 | 3.2% |
| S | 6994 | 2.7% |
| D | 6716 | 2.6% |
| T | 6489 | 2.5% |
| C | 6203 | 2.4% |
| N | 5486 | 2.2% |
| Other values (16) | 59226 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 83753 | |
| A | 49490 | |
| R | 13642 | 5.4% |
| L | 8637 | 3.4% |
| O | 8211 | 3.2% |
| S | 6994 | 2.7% |
| D | 6716 | 2.6% |
| T | 6489 | 2.5% |
| C | 6203 | 2.4% |
| N | 5486 | 2.2% |
| Other values (16) | 59226 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 83753 | |
| A | 49490 | |
| R | 13642 | 5.4% |
| L | 8637 | 3.4% |
| O | 8211 | 3.2% |
| S | 6994 | 2.7% |
| D | 6716 | 2.6% |
| T | 6489 | 2.5% |
| C | 6203 | 2.4% |
| N | 5486 | 2.2% |
| Other values (16) | 59226 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 83753 | |
| A | 49490 | |
| R | 13642 | 5.4% |
| L | 8637 | 3.4% |
| O | 8211 | 3.2% |
| S | 6994 | 2.7% |
| D | 6716 | 2.6% |
| T | 6489 | 2.5% |
| C | 6203 | 2.4% |
| N | 5486 | 2.2% |
| Other values (16) | 59226 |
coupon_range
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 83 |
| Missing (%) | 0.1% |
| Memory size | 4.1 MiB |
| SH | |
|---|---|
| LH | |
| MH | 16 |
| DOM | 4 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.0000471 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SH |
|---|---|
| 2nd row | LH |
| 3rd row | SH |
| 4th row | LH |
| 5th row | SH |
Common Values
| Value | Count | Frequency (%) |
| SH | 66652 | |
| LH | 18194 | 21.4% |
| MH | 16 | < 0.1% |
| DOM | 4 | < 0.1% |
| (Missing) | 83 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| sh | 66652 | |
| lh | 18194 | 21.4% |
| mh | 16 | < 0.1% |
| dom | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| H | 84862 | |
| S | 66652 | |
| L | 18194 | 10.7% |
| M | 20 | < 0.1% |
| D | 4 | < 0.1% |
| O | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 169736 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| H | 84862 | |
| S | 66652 | |
| L | 18194 | 10.7% |
| M | 20 | < 0.1% |
| D | 4 | < 0.1% |
| O | 4 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 169736 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| H | 84862 | |
| S | 66652 | |
| L | 18194 | 10.7% |
| M | 20 | < 0.1% |
| D | 4 | < 0.1% |
| O | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 169736 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| H | 84862 | |
| S | 66652 | |
| L | 18194 | 10.7% |
| M | 20 | < 0.1% |
| D | 4 | < 0.1% |
| O | 4 | < 0.1% |
coupon_rbd_code
Categorical
High correlation 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 MiB |
| 05aa66ad90564e9caf593f69bf0df44c | |
|---|---|
| 06461e5ef0bb4941995dadba33f4b58a | |
| 5b4d18c017084084b2c8e3860625237e | |
| b6460aef6f204ba8940329aa9f7f99cd | |
| 22da46f1ddc1406e8e6aa78cdf573c16 | |
| Other values (19) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | b6460aef6f204ba8940329aa9f7f99cd |
|---|---|
| 2nd row | 5b4d18c017084084b2c8e3860625237e |
| 3rd row | fcd7f2fe3e034355bcc3fff350b5c928 |
| 4th row | 06461e5ef0bb4941995dadba33f4b58a |
| 5th row | fcd7f2fe3e034355bcc3fff350b5c928 |
Common Values
| Value | Count | Frequency (%) |
| 05aa66ad90564e9caf593f69bf0df44c | 12620 | |
| 06461e5ef0bb4941995dadba33f4b58a | 12535 | |
| 5b4d18c017084084b2c8e3860625237e | 12354 | |
| b6460aef6f204ba8940329aa9f7f99cd | 10914 | |
| 22da46f1ddc1406e8e6aa78cdf573c16 | 9298 | |
| ebfd18e17bd1415eaa2aed61ea147c7b | 8523 | |
| fcd7f2fe3e034355bcc3fff350b5c928 | 6054 | |
| 6279682d7eab443facc4f8d077e5d4d2 | 4217 | 5.0% |
| b83de1e4d0124e4da7fddad09c0d6f2c | 2585 | 3.0% |
| 14564119eaff427699aadaa8c262d981 | 1677 | 2.0% |
| Other values (14) | 4172 | 4.9% |
Length
| Value | Count | Frequency (%) |
| 05aa66ad90564e9caf593f69bf0df44c | 12620 | |
| 06461e5ef0bb4941995dadba33f4b58a | 12535 | |
| 5b4d18c017084084b2c8e3860625237e | 12354 | |
| b6460aef6f204ba8940329aa9f7f99cd | 10914 | |
| 22da46f1ddc1406e8e6aa78cdf573c16 | 9298 | |
| ebfd18e17bd1415eaa2aed61ea147c7b | 8523 | |
| fcd7f2fe3e034355bcc3fff350b5c928 | 6054 | |
| 6279682d7eab443facc4f8d077e5d4d2 | 4217 | 5.0% |
| b83de1e4d0124e4da7fddad09c0d6f2c | 2585 | 3.0% |
| 14564119eaff427699aadaa8c262d981 | 1677 | 2.0% |
| Other values (14) | 4172 | 4.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 239739 | 8.8% |
| a | 225136 | 8.3% |
| f | 206933 | 7.6% |
| 6 | 202126 | 7.4% |
| d | 194013 | 7.1% |
| 0 | 184453 | 6.8% |
| e | 177581 | 6.5% |
| 9 | 170655 | 6.3% |
| b | 161936 | 6.0% |
| 5 | 158471 | 5.8% |
| Other values (6) | 797325 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 239739 | 8.8% |
| a | 225136 | 8.3% |
| f | 206933 | 7.6% |
| 6 | 202126 | 7.4% |
| d | 194013 | 7.1% |
| 0 | 184453 | 6.8% |
| e | 177581 | 6.5% |
| 9 | 170655 | 6.3% |
| b | 161936 | 6.0% |
| 5 | 158471 | 5.8% |
| Other values (6) | 797325 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 239739 | 8.8% |
| a | 225136 | 8.3% |
| f | 206933 | 7.6% |
| 6 | 202126 | 7.4% |
| d | 194013 | 7.1% |
| 0 | 184453 | 6.8% |
| e | 177581 | 6.5% |
| 9 | 170655 | 6.3% |
| b | 161936 | 6.0% |
| 5 | 158471 | 5.8% |
| Other values (6) | 797325 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 239739 | 8.8% |
| a | 225136 | 8.3% |
| f | 206933 | 7.6% |
| 6 | 202126 | 7.4% |
| d | 194013 | 7.1% |
| 0 | 184453 | 6.8% |
| e | 177581 | 6.5% |
| 9 | 170655 | 6.3% |
| b | 161936 | 6.0% |
| 5 | 158471 | 5.8% |
| Other values (6) | 797325 |
email
Text
| Distinct | 78461 |
|---|---|
| Distinct (%) | 92.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 72862 ? |
|---|---|
| Unique (%) | 85.8% |
Sample
| 1st row | 4a0d5a2fe1974c1f8e8082afa8bdd72b |
|---|---|
| 2nd row | eb3f322048494f7ea59d63bb636772c8 |
| 3rd row | 93fe4d004f074298ae540784f5466926 |
| 4th row | a9a8894fee5d44da923224e46a280e9c |
| 5th row | 7e7a981bfcff46aa9077f2dd2803ac57 |
| Value | Count | Frequency (%) |
| e33ffa74e7434baeb477b7439a0b7c4f | 11 | < 0.1% |
| a137146494704591a3b9c63ec4535497 | 9 | < 0.1% |
| 56fe73d8898a485da07de143a35bda4e | 9 | < 0.1% |
| 6d9548f90748425f85eb3145cb8f72a0 | 8 | < 0.1% |
| f740d3077d5d4081ab05c37550fb9d38 | 8 | < 0.1% |
| 8a92239cf35142bbbded084f20526b50 | 8 | < 0.1% |
| 5fd440d299ca472c9dd168dd8dec02f9 | 8 | < 0.1% |
| a01224c98a50439a9f14a307649d8611 | 8 | < 0.1% |
| bd467efbd63644b390ecc9888fa6f549 | 7 | < 0.1% |
| dc1fa8efaef240df945096e8652d859a | 7 | < 0.1% |
| Other values (78451) | 84866 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 244785 | 9.0% |
| 8 | 181055 | 6.7% |
| b | 180507 | 6.6% |
| 9 | 180430 | 6.6% |
| a | 179733 | 6.6% |
| 5 | 159884 | 5.9% |
| 7 | 159596 | 5.9% |
| 6 | 159477 | 5.9% |
| 1 | 159311 | 5.9% |
| 0 | 159305 | 5.9% |
| Other values (6) | 954285 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 244785 | 9.0% |
| 8 | 181055 | 6.7% |
| b | 180507 | 6.6% |
| 9 | 180430 | 6.6% |
| a | 179733 | 6.6% |
| 5 | 159884 | 5.9% |
| 7 | 159596 | 5.9% |
| 6 | 159477 | 5.9% |
| 1 | 159311 | 5.9% |
| 0 | 159305 | 5.9% |
| Other values (6) | 954285 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 244785 | 9.0% |
| 8 | 181055 | 6.7% |
| b | 180507 | 6.6% |
| 9 | 180430 | 6.6% |
| a | 179733 | 6.6% |
| 5 | 159884 | 5.9% |
| 7 | 159596 | 5.9% |
| 6 | 159477 | 5.9% |
| 1 | 159311 | 5.9% |
| 0 | 159305 | 5.9% |
| Other values (6) | 954285 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 244785 | 9.0% |
| 8 | 181055 | 6.7% |
| b | 180507 | 6.6% |
| 9 | 180430 | 6.6% |
| a | 179733 | 6.6% |
| 5 | 159884 | 5.9% |
| 7 | 159596 | 5.9% |
| 6 | 159477 | 5.9% |
| 1 | 159311 | 5.9% |
| 0 | 159305 | 5.9% |
| Other values (6) | 954285 |
flight_coupon_id
Real number (ℝ)
| Distinct | 84801 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5512027.7 |
| Minimum | 1000251 |
|---|---|
| Maximum | 9999912 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1000251 |
|---|---|
| 5-th percentile | 1454788.4 |
| Q1 | 3267038 |
| median | 5515807 |
| Q3 | 7772667 |
| 95-th percentile | 9556895.2 |
| Maximum | 9999912 |
| Range | 8999661 |
| Interquartile range (IQR) | 4505629 |
Descriptive statistics
| Standard deviation | 2601157.5 |
|---|---|
| Coefficient of variation (CV) | 0.47190573 |
| Kurtosis | -1.203918 |
| Mean | 5512027.7 |
| Median Absolute Deviation (MAD) | 2252612 |
| Skewness | -0.002003187 |
| Sum | 4.6824125 × 1011 |
| Variance | 6.7660203 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2721744 | 3 | < 0.1% |
| 2900124 | 3 | < 0.1% |
| 9811869 | 2 | < 0.1% |
| 9579095 | 2 | < 0.1% |
| 8874794 | 2 | < 0.1% |
| 8918055 | 2 | < 0.1% |
| 9990696 | 2 | < 0.1% |
| 1313193 | 2 | < 0.1% |
| 9651429 | 2 | < 0.1% |
| 9355764 | 2 | < 0.1% |
| Other values (84791) | 84927 |
| Value | Count | Frequency (%) |
| 1000251 | 1 | |
| 1000624 | 1 | |
| 1000688 | 1 | |
| 1000790 | 1 | |
| 1000843 | 1 | |
| 1000857 | 1 | |
| 1000895 | 1 | |
| 1000967 | 1 | |
| 1001110 | 1 | |
| 1001261 | 1 |
| Value | Count | Frequency (%) |
| 9999912 | 1 | |
| 9999846 | 1 | |
| 9999781 | 1 | |
| 9999708 | 1 | |
| 9999669 | 1 | |
| 9999629 | 1 | |
| 9999599 | 1 | |
| 9999588 | 1 | |
| 9999484 | 1 | |
| 9999457 | 1 |
flight_leg_id
Real number (ℝ)
| Distinct | 84782 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5516877.9 |
| Minimum | 1000077 |
|---|---|
| Maximum | 9999791 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1000077 |
|---|---|
| 5-th percentile | 1455697.6 |
| Q1 | 3270782 |
| median | 5525110 |
| Q3 | 7758842 |
| 95-th percentile | 9552604.8 |
| Maximum | 9999791 |
| Range | 8999714 |
| Interquartile range (IQR) | 4488060 |
Descriptive statistics
| Standard deviation | 2595148.5 |
|---|---|
| Coefficient of variation (CV) | 0.47040166 |
| Kurtosis | -1.1977262 |
| Mean | 5516877.9 |
| Median Absolute Deviation (MAD) | 2244565 |
| Skewness | -0.013353815 |
| Sum | 4.6865326 × 1011 |
| Variance | 6.734796 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6960253 | 3 | < 0.1% |
| 8118766 | 3 | < 0.1% |
| 2900072 | 2 | < 0.1% |
| 6517808 | 2 | < 0.1% |
| 6846697 | 2 | < 0.1% |
| 7925363 | 2 | < 0.1% |
| 4319337 | 2 | < 0.1% |
| 8863313 | 2 | < 0.1% |
| 7883876 | 2 | < 0.1% |
| 4219254 | 2 | < 0.1% |
| Other values (84772) | 84927 |
| Value | Count | Frequency (%) |
| 1000077 | 1 | |
| 1000190 | 1 | |
| 1000207 | 1 | |
| 1000357 | 1 | |
| 1000406 | 1 | |
| 1000412 | 1 | |
| 1000561 | 1 | |
| 1000615 | 1 | |
| 1000673 | 1 | |
| 1000786 | 1 |
| Value | Count | Frequency (%) |
| 9999791 | 1 | |
| 9999680 | 1 | |
| 9999622 | 1 | |
| 9999574 | 1 | |
| 9999565 | 1 | |
| 9999461 | 1 | |
| 9999445 | 1 | |
| 9999321 | 1 | |
| 9999209 | 1 | |
| 9998966 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 53368 | |
| 1 | 31581 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 53368 | |
| 1 | 31581 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 53368 | |
| 1 | 31581 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 53368 | |
| 1 | 31581 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 53368 | |
| 1 | 31581 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 53368 | |
| 1 | 31581 |
leg_arrival_hour
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.747931 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 820 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 11 |
| median | 16 |
| Q3 | 19 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.3561062 |
|---|---|
| Coefficient of variation (CV) | 0.36317678 |
| Kurtosis | -0.273186 |
| Mean | 14.747931 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.59319882 |
| Sum | 1252822 |
| Variance | 28.687873 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 8824 | |
| 13 | 7692 | 9.1% |
| 18 | 7597 | 8.9% |
| 19 | 6989 | 8.2% |
| 17 | 6695 | 7.9% |
| 21 | 6219 | 7.3% |
| 12 | 6145 | 7.2% |
| 22 | 5337 | 6.3% |
| 20 | 5040 | 5.9% |
| 14 | 3884 | 4.6% |
| Other values (14) | 20527 |
| Value | Count | Frequency (%) |
| 0 | 820 | 1.0% |
| 1 | 1094 | 1.3% |
| 2 | 734 | 0.9% |
| 3 | 316 | 0.4% |
| 4 | 1034 | 1.2% |
| 5 | 986 | 1.2% |
| 6 | 1594 | 1.9% |
| 7 | 649 | 0.8% |
| 8 | 1658 | 2.0% |
| 9 | 8824 |
| Value | Count | Frequency (%) |
| 23 | 1453 | 1.7% |
| 22 | 5337 | |
| 21 | 6219 | |
| 20 | 5040 | |
| 19 | 6989 | |
| 18 | 7597 | |
| 17 | 6695 | |
| 16 | 3410 | |
| 15 | 3157 | |
| 14 | 3884 |
| Distinct | 52 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.1 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 13 |
| Mean length | 13.532155 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Europe/Warsaw |
|---|---|
| 2nd row | America/New_York |
| 3rd row | Europe/Warsaw |
| 4th row | Asia/Kolkata |
| 5th row | Europe/Bucharest |
| Value | Count | Frequency (%) |
| europe/warsaw | 32045 | |
| europe/berlin | 4020 | 4.7% |
| america/new_york | 3773 | 4.4% |
| europe/london | 3051 | 3.6% |
| europe/vilnius | 2312 | 2.7% |
| america/chicago | 2157 | 2.5% |
| europe/zurich | 2126 | 2.5% |
| europe/amsterdam | 2087 | 2.5% |
| europe/paris | 1950 | 2.3% |
| europe/bucharest | 1901 | 2.2% |
| Other values (42) | 29527 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 137263 | |
| e | 107219 | 9.3% |
| a | 106718 | 9.3% |
| o | 101734 | 8.8% |
| u | 85275 | 7.4% |
| / | 84949 | 7.4% |
| p | 72624 | 6.3% |
| E | 69896 | 6.1% |
| s | 58511 | 5.1% |
| i | 41130 | 3.6% |
| Other values (35) | 284224 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1149543 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 137263 | |
| e | 107219 | 9.3% |
| a | 106718 | 9.3% |
| o | 101734 | 8.8% |
| u | 85275 | 7.4% |
| / | 84949 | 7.4% |
| p | 72624 | 6.3% |
| E | 69896 | 6.1% |
| s | 58511 | 5.1% |
| i | 41130 | 3.6% |
| Other values (35) | 284224 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1149543 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 137263 | |
| e | 107219 | 9.3% |
| a | 106718 | 9.3% |
| o | 101734 | 8.8% |
| u | 85275 | 7.4% |
| / | 84949 | 7.4% |
| p | 72624 | 6.3% |
| E | 69896 | 6.1% |
| s | 58511 | 5.1% |
| i | 41130 | 3.6% |
| Other values (35) | 284224 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1149543 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 137263 | |
| e | 107219 | 9.3% |
| a | 106718 | 9.3% |
| o | 101734 | 8.8% |
| u | 85275 | 7.4% |
| / | 84949 | 7.4% |
| p | 72624 | 6.3% |
| E | 69896 | 6.1% |
| s | 58511 | 5.1% |
| i | 41130 | 3.6% |
| Other values (35) | 284224 |
leg_departure_hour
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.763505 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 18 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 10 |
| median | 14 |
| Q3 | 18 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.0518301 |
|---|---|
| Coefficient of variation (CV) | 0.36704531 |
| Kurtosis | -1.0384471 |
| Mean | 13.763505 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.11599134 |
| Sum | 1169196 |
| Variance | 25.520987 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 8910 | 10.5% |
| 19 | 8420 | 9.9% |
| 7 | 7730 | 9.1% |
| 14 | 6902 | 8.1% |
| 17 | 6478 | 7.6% |
| 16 | 6303 | 7.4% |
| 18 | 4993 | 5.9% |
| 22 | 4285 | 5.0% |
| 12 | 3996 | 4.7% |
| 8 | 3732 | 4.4% |
| Other values (14) | 23200 |
| Value | Count | Frequency (%) |
| 0 | 18 | < 0.1% |
| 1 | 251 | 0.3% |
| 2 | 55 | 0.1% |
| 3 | 321 | 0.4% |
| 4 | 273 | 0.3% |
| 5 | 2647 | 3.1% |
| 6 | 1955 | 2.3% |
| 7 | 7730 | |
| 8 | 3732 | |
| 9 | 2505 | 2.9% |
| Value | Count | Frequency (%) |
| 23 | 1256 | 1.5% |
| 22 | 4285 | |
| 21 | 1678 | 2.0% |
| 20 | 3175 | 3.7% |
| 19 | 8420 | |
| 18 | 4993 | |
| 17 | 6478 | |
| 16 | 6303 | |
| 15 | 3448 | |
| 14 | 6902 |
leg_departure_month
Real number (ℝ)
High correlation 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4200873 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 9 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 3.3561857 |
|---|---|
| Coefficient of variation (CV) | 0.39859274 |
| Kurtosis | 0.12347817 |
| Mean | 8.4200873 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.2618251 |
| Sum | 715278 |
| Variance | 11.263982 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 24732 | |
| 10 | 23219 | |
| 11 | 10909 | |
| 12 | 8322 | 9.8% |
| 2 | 7470 | 8.8% |
| 1 | 5042 | 5.9% |
| 3 | 4277 | 5.0% |
| 8 | 978 | 1.2% |
| Value | Count | Frequency (%) |
| 1 | 5042 | 5.9% |
| 2 | 7470 | 8.8% |
| 3 | 4277 | 5.0% |
| 8 | 978 | 1.2% |
| 9 | 24732 | |
| 10 | 23219 | |
| 11 | 10909 | |
| 12 | 8322 | 9.8% |
| Value | Count | Frequency (%) |
| 12 | 8322 | 9.8% |
| 11 | 10909 | |
| 10 | 23219 | |
| 9 | 24732 | |
| 8 | 978 | 1.2% |
| 3 | 4277 | 5.0% |
| 2 | 7470 | 8.8% |
| 1 | 5042 | 5.9% |
| Distinct | 52 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.1 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 13 |
| Mean length | 13.507281 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Asia/Tbilisi |
|---|---|
| 2nd row | Europe/Warsaw |
| 3rd row | Europe/Belgrade |
| 4th row | Europe/Warsaw |
| 5th row | Europe/Oslo |
| Value | Count | Frequency (%) |
| europe/warsaw | 33380 | |
| europe/berlin | 3828 | 4.5% |
| america/new_york | 3192 | 3.8% |
| europe/london | 2817 | 3.3% |
| europe/vilnius | 2583 | 3.0% |
| europe/bucharest | 2037 | 2.4% |
| europe/zurich | 1849 | 2.2% |
| america/chicago | 1829 | 2.2% |
| europe/paris | 1787 | 2.1% |
| europe/amsterdam | 1747 | 2.1% |
| Other values (42) | 29900 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 137280 | |
| a | 108478 | 9.5% |
| e | 106334 | 9.3% |
| o | 100964 | 8.8% |
| u | 86856 | 7.6% |
| / | 84949 | 7.4% |
| p | 74077 | 6.5% |
| E | 71354 | 6.2% |
| s | 59466 | 5.2% |
| i | 40236 | 3.5% |
| Other values (35) | 277436 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1147430 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 137280 | |
| a | 108478 | 9.5% |
| e | 106334 | 9.3% |
| o | 100964 | 8.8% |
| u | 86856 | 7.6% |
| / | 84949 | 7.4% |
| p | 74077 | 6.5% |
| E | 71354 | 6.2% |
| s | 59466 | 5.2% |
| i | 40236 | 3.5% |
| Other values (35) | 277436 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1147430 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 137280 | |
| a | 108478 | 9.5% |
| e | 106334 | 9.3% |
| o | 100964 | 8.8% |
| u | 86856 | 7.6% |
| / | 84949 | 7.4% |
| p | 74077 | 6.5% |
| E | 71354 | 6.2% |
| s | 59466 | 5.2% |
| i | 40236 | 3.5% |
| Other values (35) | 277436 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1147430 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 137280 | |
| a | 108478 | 9.5% |
| e | 106334 | 9.3% |
| o | 100964 | 8.8% |
| u | 86856 | 7.6% |
| / | 84949 | 7.4% |
| p | 74077 | 6.5% |
| E | 71354 | 6.2% |
| s | 59466 | 5.2% |
| i | 40236 | 3.5% |
| Other values (35) | 277436 |
| Distinct | 87 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WAW |
|---|---|
| 2nd row | EWR |
| 3rd row | SZZ |
| 4th row | BOM |
| 5th row | OTP |
| Value | Count | Frequency (%) |
| waw | 27264 | |
| lhr | 2662 | 3.1% |
| vno | 2312 | 2.7% |
| ord | 2157 | 2.5% |
| ams | 2087 | 2.5% |
| jfk | 2085 | 2.5% |
| yyz | 1861 | 2.2% |
| krk | 1820 | 2.1% |
| otp | 1536 | 1.8% |
| prg | 1451 | 1.7% |
| Other values (77) | 39714 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 56496 | |
| A | 37465 | |
| R | 18683 | 7.3% |
| O | 11409 | 4.5% |
| L | 10681 | 4.2% |
| D | 8944 | 3.5% |
| T | 8303 | 3.3% |
| S | 8116 | 3.2% |
| N | 7800 | 3.1% |
| C | 7744 | 3.0% |
| Other values (16) | 79206 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 56496 | |
| A | 37465 | |
| R | 18683 | 7.3% |
| O | 11409 | 4.5% |
| L | 10681 | 4.2% |
| D | 8944 | 3.5% |
| T | 8303 | 3.3% |
| S | 8116 | 3.2% |
| N | 7800 | 3.1% |
| C | 7744 | 3.0% |
| Other values (16) | 79206 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 56496 | |
| A | 37465 | |
| R | 18683 | 7.3% |
| O | 11409 | 4.5% |
| L | 10681 | 4.2% |
| D | 8944 | 3.5% |
| T | 8303 | 3.3% |
| S | 8116 | 3.2% |
| N | 7800 | 3.1% |
| C | 7744 | 3.0% |
| Other values (16) | 79206 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 56496 | |
| A | 37465 | |
| R | 18683 | 7.3% |
| O | 11409 | 4.5% |
| L | 10681 | 4.2% |
| D | 8944 | 3.5% |
| T | 8303 | 3.3% |
| S | 8116 | 3.2% |
| N | 7800 | 3.1% |
| C | 7744 | 3.0% |
| Other values (16) | 79206 |
leg_destination_country_code
Categorical
High correlation  Missing 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 65106 |
| Missing (%) | 76.6% |
| Memory size | 4.4 MiB |
| PL | |
|---|---|
| US | |
| DE | 744 |
| IT | 679 |
| CH | 608 |
| Other values (40) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | PL |
| 3rd row | PL |
| 4th row | DK |
| 5th row | CZ |
Common Values
| Value | Count | Frequency (%) |
| PL | 8932 | 10.5% |
| US | 2281 | 2.7% |
| DE | 744 | 0.9% |
| IT | 679 | 0.8% |
| CH | 608 | 0.7% |
| GB | 561 | 0.7% |
| NL | 524 | 0.6% |
| FR | 511 | 0.6% |
| ES | 435 | 0.5% |
| TR | 434 | 0.5% |
| Other values (35) | 4134 | 4.9% |
| (Missing) | 65106 |
Length
| Value | Count | Frequency (%) |
| pl | 8932 | |
| us | 2281 | 11.5% |
| de | 744 | 3.7% |
| it | 679 | 3.4% |
| ch | 608 | 3.1% |
| gb | 561 | 2.8% |
| nl | 524 | 2.6% |
| fr | 511 | 2.6% |
| es | 435 | 2.2% |
| tr | 434 | 2.2% |
| Other values (35) | 4134 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 9783 | |
| P | 9216 | |
| S | 3041 | 7.7% |
| U | 2543 | 6.4% |
| E | 2253 | 5.7% |
| R | 1639 | 4.1% |
| T | 1344 | 3.4% |
| G | 1177 | 3.0% |
| C | 1154 | 2.9% |
| B | 1007 | 2.5% |
| Other values (13) | 6529 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39686 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 9783 | |
| P | 9216 | |
| S | 3041 | 7.7% |
| U | 2543 | 6.4% |
| E | 2253 | 5.7% |
| R | 1639 | 4.1% |
| T | 1344 | 3.4% |
| G | 1177 | 3.0% |
| C | 1154 | 2.9% |
| B | 1007 | 2.5% |
| Other values (13) | 6529 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39686 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 9783 | |
| P | 9216 | |
| S | 3041 | 7.7% |
| U | 2543 | 6.4% |
| E | 2253 | 5.7% |
| R | 1639 | 4.1% |
| T | 1344 | 3.4% |
| G | 1177 | 3.0% |
| C | 1154 | 2.9% |
| B | 1007 | 2.5% |
| Other values (13) | 6529 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39686 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 9783 | |
| P | 9216 | |
| S | 3041 | 7.7% |
| U | 2543 | 6.4% |
| E | 2253 | 5.7% |
| R | 1639 | 4.1% |
| T | 1344 | 3.4% |
| G | 1177 | 3.0% |
| C | 1154 | 2.9% |
| B | 1007 | 2.5% |
| Other values (13) | 6529 |
leg_duration_h
Real number (ℝ)
Zeros 
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8904755 |
| Minimum | 0 |
|---|---|
| Maximum | 45 |
| Zeros | 3115 |
| Zeros (%) | 3.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 18 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 5.4787245 |
|---|---|
| Coefficient of variation (CV) | 1.1202846 |
| Kurtosis | 4.4896323 |
| Mean | 4.8904755 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 2.0912358 |
| Sum | 415441 |
| Variance | 30.016422 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 17585 | |
| 2 | 16889 | |
| 3 | 13704 | |
| 4 | 7083 | |
| 5 | 5352 | 6.3% |
| 6 | 3564 | 4.2% |
| 0 | 3115 | 3.7% |
| 14 | 2866 | 3.4% |
| 7 | 2369 | 2.8% |
| 16 | 1614 | 1.9% |
| Other values (35) | 10808 |
| Value | Count | Frequency (%) |
| 0 | 3115 | 3.7% |
| 1 | 17585 | |
| 2 | 16889 | |
| 3 | 13704 | |
| 4 | 7083 | |
| 5 | 5352 | 6.3% |
| 6 | 3564 | 4.2% |
| 7 | 2369 | 2.8% |
| 8 | 1377 | 1.6% |
| 9 | 1251 | 1.5% |
| Value | Count | Frequency (%) |
| 45 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 41 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 39 | 6 | < 0.1% |
| 38 | 4 | < 0.1% |
| 37 | 3 | < 0.1% |
| 36 | 4 | < 0.1% |
| 35 | 36 |
leg_first_leg_flg
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 53664 | |
| 0 | 31285 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 53664 | |
| 0 | 31285 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 53664 | |
| 0 | 31285 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 53664 | |
| 0 | 31285 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 53664 | |
| 0 | 31285 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 53664 | |
| 0 | 31285 |
leg_hours_to_departure
Real number (ℝ)
High correlation 
| Distinct | 18 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70.753111 |
| Minimum | 61 |
|---|---|
| Maximum | 80 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 61 |
|---|---|
| 5-th percentile | 65 |
| Q1 | 71 |
| median | 71 |
| Q3 | 71 |
| 95-th percentile | 73 |
| Maximum | 80 |
| Range | 19 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.2920686 |
|---|---|
| Coefficient of variation (CV) | 0.032395305 |
| Kurtosis | 5.0003351 |
| Mean | 70.753111 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.1170164 |
| Sum | 6010406 |
| Variance | 5.2535785 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 71 | 55888 | |
| 72 | 10344 | 12.2% |
| 70 | 5579 | 6.6% |
| 65 | 4543 | 5.3% |
| 64 | 1687 | 2.0% |
| 74 | 1571 | 1.8% |
| 73 | 1302 | 1.5% |
| 78 | 1100 | 1.3% |
| 75 | 935 | 1.1% |
| 62 | 593 | 0.7% |
| Other values (8) | 1407 | 1.7% |
| Value | Count | Frequency (%) |
| 61 | 103 | 0.1% |
| 62 | 593 | 0.7% |
| 63 | 79 | 0.1% |
| 64 | 1687 | 2.0% |
| 65 | 4543 | 5.3% |
| 66 | 329 | 0.4% |
| 69 | 337 | 0.4% |
| 70 | 5579 | 6.6% |
| 71 | 55888 | |
| 72 | 10344 | 12.2% |
| Value | Count | Frequency (%) |
| 80 | 21 | < 0.1% |
| 79 | 314 | 0.4% |
| 78 | 1100 | 1.3% |
| 77 | 69 | 0.1% |
| 76 | 155 | 0.2% |
| 75 | 935 | 1.1% |
| 74 | 1571 | 1.8% |
| 73 | 1302 | 1.5% |
| 72 | 10344 | 12.2% |
| 71 | 55888 |
leg_last_leg_flg
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 54020 | |
| 0 | 30929 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 54020 | |
| 0 | 30929 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 54020 | |
| 0 | 30929 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 54020 | |
| 0 | 30929 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 54020 | |
| 0 | 30929 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 54020 | |
| 0 | 30929 |
leg_number
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 80 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 57564 | |
| 2 | 27305 | |
| 3 | 80 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 57564 | |
| 2 | 27305 | |
| 3 | 80 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 57564 | |
| 2 | 27305 | |
| 3 | 80 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 57564 | |
| 2 | 27305 | |
| 3 | 80 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 57564 | |
| 2 | 27305 | |
| 3 | 80 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 57564 | |
| 2 | 27305 | |
| 3 | 80 | 0.1% |
| Distinct | 87 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TBS |
|---|---|
| 2nd row | WAW |
| 3rd row | BEG |
| 4th row | WAW |
| 5th row | OSL |
| Value | Count | Frequency (%) |
| waw | 28484 | |
| vno | 2583 | 3.0% |
| lhr | 2472 | 2.9% |
| krk | 1873 | 2.2% |
| ord | 1829 | 2.2% |
| ams | 1747 | 2.1% |
| jfk | 1707 | 2.0% |
| otp | 1599 | 1.9% |
| tll | 1579 | 1.9% |
| yyz | 1565 | 1.8% |
| Other values (77) | 39511 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 58868 | |
| A | 38077 | |
| R | 18022 | 7.1% |
| O | 11721 | 4.6% |
| L | 10867 | 4.3% |
| T | 8828 | 3.5% |
| D | 8499 | 3.3% |
| S | 8454 | 3.3% |
| N | 7836 | 3.1% |
| C | 7217 | 2.8% |
| Other values (16) | 76458 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 58868 | |
| A | 38077 | |
| R | 18022 | 7.1% |
| O | 11721 | 4.6% |
| L | 10867 | 4.3% |
| T | 8828 | 3.5% |
| D | 8499 | 3.3% |
| S | 8454 | 3.3% |
| N | 7836 | 3.1% |
| C | 7217 | 2.8% |
| Other values (16) | 76458 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 58868 | |
| A | 38077 | |
| R | 18022 | 7.1% |
| O | 11721 | 4.6% |
| L | 10867 | 4.3% |
| T | 8828 | 3.5% |
| D | 8499 | 3.3% |
| S | 8454 | 3.3% |
| N | 7836 | 3.1% |
| C | 7217 | 2.8% |
| Other values (16) | 76458 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 254847 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 58868 | |
| A | 38077 | |
| R | 18022 | 7.1% |
| O | 11721 | 4.6% |
| L | 10867 | 4.3% |
| T | 8828 | 3.5% |
| D | 8499 | 3.3% |
| S | 8454 | 3.3% |
| N | 7836 | 3.1% |
| C | 7217 | 2.8% |
| Other values (16) | 76458 |
leg_origin_country_code
Categorical
High correlation  Missing 
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 65079 |
| Missing (%) | 76.6% |
| Memory size | 4.4 MiB |
| PL | |
|---|---|
| US | |
| DE | 673 |
| IT | 519 |
| GB | 466 |
| Other values (39) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ES |
|---|---|
| 2nd row | KR |
| 3rd row | PL |
| 4th row | PL |
| 5th row | CH |
Common Values
| Value | Count | Frequency (%) |
| PL | 10611 | 12.5% |
| US | 1956 | 2.3% |
| DE | 673 | 0.8% |
| IT | 519 | 0.6% |
| GB | 466 | 0.5% |
| CH | 460 | 0.5% |
| FR | 443 | 0.5% |
| ES | 388 | 0.5% |
| NL | 385 | 0.5% |
| TR | 345 | 0.4% |
| Other values (34) | 3624 | 4.3% |
| (Missing) | 65079 |
Length
| Value | Count | Frequency (%) |
| pl | 10611 | |
| us | 1956 | 9.8% |
| de | 673 | 3.4% |
| it | 519 | 2.6% |
| gb | 466 | 2.3% |
| ch | 460 | 2.3% |
| fr | 443 | 2.2% |
| es | 388 | 2.0% |
| nl | 385 | 1.9% |
| tr | 345 | 1.7% |
| Other values (34) | 3624 | 18.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 11259 | |
| P | 10793 | |
| S | 2662 | 6.7% |
| U | 2191 | 5.5% |
| E | 2003 | 5.0% |
| R | 1442 | 3.6% |
| T | 1058 | 2.7% |
| G | 994 | 2.5% |
| C | 885 | 2.2% |
| D | 874 | 2.2% |
| Other values (13) | 5579 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 39740 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 11259 | |
| P | 10793 | |
| S | 2662 | 6.7% |
| U | 2191 | 5.5% |
| E | 2003 | 5.0% |
| R | 1442 | 3.6% |
| T | 1058 | 2.7% |
| G | 994 | 2.5% |
| C | 885 | 2.2% |
| D | 874 | 2.2% |
| Other values (13) | 5579 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 39740 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 11259 | |
| P | 10793 | |
| S | 2662 | 6.7% |
| U | 2191 | 5.5% |
| E | 2003 | 5.0% |
| R | 1442 | 3.6% |
| T | 1058 | 2.7% |
| G | 994 | 2.5% |
| C | 885 | 2.2% |
| D | 874 | 2.2% |
| Other values (13) | 5579 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 39740 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 11259 | |
| P | 10793 | |
| S | 2662 | 6.7% |
| U | 2191 | 5.5% |
| E | 2003 | 5.0% |
| R | 1442 | 3.6% |
| T | 1058 | 2.7% |
| G | 994 | 2.5% |
| C | 885 | 2.2% |
| D | 874 | 2.2% |
| Other values (13) | 5579 |
leg_stopover_time_h
Real number (ℝ)
High correlation 
| Distinct | 2031 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -6240.4644 |
| Minimum | -9999 |
|---|---|
| Maximum | 8771 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 54020 |
| Negative (%) | 63.6% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | -9999 |
| Q1 | -9999 |
| median | -9999 |
| Q3 | 99 |
| 95-th percentile | 492 |
| Maximum | 8771 |
| Range | 18770 |
| Interquartile range (IQR) | 10098 |
Descriptive statistics
| Standard deviation | 4980.8746 |
|---|---|
| Coefficient of variation (CV) | -0.79815767 |
| Kurtosis | -1.6120766 |
| Mean | -6240.4644 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.58604442 |
| Sum | -5.3012121 × 108 |
| Variance | 24809111 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -9999 | 54020 | |
| 75 | 479 | 0.6% |
| 84 | 393 | 0.5% |
| 74 | 392 | 0.5% |
| 99 | 351 | 0.4% |
| 79 | 287 | 0.3% |
| 51 | 285 | 0.3% |
| 76 | 285 | 0.3% |
| 77 | 280 | 0.3% |
| 108 | 260 | 0.3% |
| Other values (2021) | 27917 |
| Value | Count | Frequency (%) |
| -9999 | 54020 | |
| 3 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 7 | < 0.1% |
| 10 | 17 | < 0.1% |
| 11 | 8 | < 0.1% |
| 12 | 25 | < 0.1% |
| 13 | 13 | < 0.1% |
| Value | Count | Frequency (%) |
| 8771 | 1 | |
| 8616 | 1 | |
| 8602 | 1 | |
| 8555 | 1 | |
| 8412 | 1 | |
| 8411 | 1 | |
| 8290 | 1 | |
| 8214 | 1 | |
| 8127 | 1 | |
| 8117 | 1 |
pnr
Text
| Distinct | 81730 |
|---|---|
| Distinct (%) | 96.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 78610 ? |
|---|---|
| Unique (%) | 92.5% |
Sample
| 1st row | 40faefe514be47b38cea3be065583d7f |
|---|---|
| 2nd row | 7fafefddde544aba95c69552cfbadd51 |
| 3rd row | 6240c081718e4439a3174ac38a2c9c45 |
| 4th row | 231c99e3d0644366827e91276296e3cc |
| 5th row | 4854301527cf48f7a32c9625a154874b |
| Value | Count | Frequency (%) |
| 7bbdfd259c424672aaec55b4ed21012b | 11 | < 0.1% |
| 3fd51e95bf884d2d9b0950c2bc674127 | 7 | < 0.1% |
| 9846d8372bc34bfc8c49f0ea00a4a2c5 | 6 | < 0.1% |
| 8a67aa5b47a842a9b56fc29e30c65a41 | 5 | < 0.1% |
| 35789d3d925a48ac90178695077c1a20 | 5 | < 0.1% |
| e897a35961fd456b8d8ba989a418e40f | 5 | < 0.1% |
| 52afcd9f9c9949fcb40987f28572e65c | 5 | < 0.1% |
| 8f392122ed114131a7f700e24be0bc3b | 5 | < 0.1% |
| fb0fe9571e1a492ab5c081a047286fbe | 4 | < 0.1% |
| 991a40de96464afe8d3d7eef7b76b403 | 4 | < 0.1% |
| Other values (81720) | 84892 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 244297 | 9.0% |
| 9 | 180501 | 6.6% |
| a | 180332 | 6.6% |
| b | 180247 | 6.6% |
| 8 | 179880 | 6.6% |
| e | 159801 | 5.9% |
| 7 | 159637 | 5.9% |
| c | 159581 | 5.9% |
| f | 159418 | 5.9% |
| 1 | 159357 | 5.9% |
| Other values (6) | 955317 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 244297 | 9.0% |
| 9 | 180501 | 6.6% |
| a | 180332 | 6.6% |
| b | 180247 | 6.6% |
| 8 | 179880 | 6.6% |
| e | 159801 | 5.9% |
| 7 | 159637 | 5.9% |
| c | 159581 | 5.9% |
| f | 159418 | 5.9% |
| 1 | 159357 | 5.9% |
| Other values (6) | 955317 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 244297 | 9.0% |
| 9 | 180501 | 6.6% |
| a | 180332 | 6.6% |
| b | 180247 | 6.6% |
| 8 | 179880 | 6.6% |
| e | 159801 | 5.9% |
| 7 | 159637 | 5.9% |
| c | 159581 | 5.9% |
| f | 159418 | 5.9% |
| 1 | 159357 | 5.9% |
| Other values (6) | 955317 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 244297 | 9.0% |
| 9 | 180501 | 6.6% |
| a | 180332 | 6.6% |
| b | 180247 | 6.6% |
| 8 | 179880 | 6.6% |
| e | 159801 | 5.9% |
| 7 | 159637 | 5.9% |
| c | 159581 | 5.9% |
| f | 159418 | 5.9% |
| 1 | 159357 | 5.9% |
| Other values (6) | 955317 |
preffered_language
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| en_gb | |
|---|---|
| pl_pl |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | en_gb |
|---|---|
| 2nd row | en_gb |
| 3rd row | en_gb |
| 4th row | en_gb |
| 5th row | en_gb |
Common Values
| Value | Count | Frequency (%) |
| en_gb | 65438 | |
| pl_pl | 19511 | 23.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| en_gb | 65438 | |
| pl_pl | 19511 | 23.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 84949 | |
| e | 65438 | |
| n | 65438 | |
| g | 65438 | |
| b | 65438 | |
| p | 39022 | |
| l | 39022 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 424745 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| _ | 84949 | |
| e | 65438 | |
| n | 65438 | |
| g | 65438 | |
| b | 65438 | |
| p | 39022 | |
| l | 39022 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 424745 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| _ | 84949 | |
| e | 65438 | |
| n | 65438 | |
| g | 65438 | |
| b | 65438 | |
| p | 39022 | |
| l | 39022 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 424745 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| _ | 84949 | |
| e | 65438 | |
| n | 65438 | |
| g | 65438 | |
| b | 65438 | |
| p | 39022 | |
| l | 39022 |
request_dttm
Date
| Distinct | 4133 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 663.8 KiB |
| Minimum | 2013-09-14 19:04:16.417000+00:00 |
|---|---|
| Maximum | 2014-03-31 04:12:26.013000+00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
request_id
Text
| Distinct | 4133 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 169 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | ee37548ce2a74b99b41d67f4d2a138fd |
|---|---|
| 2nd row | f083457969dd46d2ada761198096ecc4 |
| 3rd row | 9df9a894f4374dfba0d8811dd99c1b1e |
| 4th row | 89c95fa040db42d4a1982c7901128585 |
| 5th row | d44b65a240374e61867039b37c98f9a0 |
| Value | Count | Frequency (%) |
| 39a540adca3c4aec9af5f90d5b0bfc1d | 146 | 0.2% |
| 000a88383de8468db61e4d1a18c827ef | 138 | 0.2% |
| 7887589e65a344a380c87efcc682456c | 117 | 0.1% |
| d5a8015576df42048f289bc9d411b80e | 115 | 0.1% |
| 699208e0cce04b66835be483ff63389c | 114 | 0.1% |
| c39075c74f2345eea9d09d21ca931bb4 | 112 | 0.1% |
| 44148fae00a44a1f9edbdb727b8dfdaf | 110 | 0.1% |
| 0770b83e2dd94da685bf6e62e78388db | 109 | 0.1% |
| cbd63f2c0ddb4a55bb7dfd6302a91a10 | 108 | 0.1% |
| 4ceaab8a97274997813ba0135dcf7ec0 | 108 | 0.1% |
| Other values (4123) | 83772 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 242452 | 8.9% |
| 8 | 183508 | 6.8% |
| a | 182636 | 6.7% |
| 9 | 181797 | 6.7% |
| b | 180619 | 6.6% |
| 1 | 164127 | 6.0% |
| 2 | 163027 | 6.0% |
| d | 159905 | 5.9% |
| 3 | 159749 | 5.9% |
| 5 | 158988 | 5.8% |
| Other values (6) | 941560 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 242452 | 8.9% |
| 8 | 183508 | 6.8% |
| a | 182636 | 6.7% |
| 9 | 181797 | 6.7% |
| b | 180619 | 6.6% |
| 1 | 164127 | 6.0% |
| 2 | 163027 | 6.0% |
| d | 159905 | 5.9% |
| 3 | 159749 | 5.9% |
| 5 | 158988 | 5.8% |
| Other values (6) | 941560 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 242452 | 8.9% |
| 8 | 183508 | 6.8% |
| a | 182636 | 6.7% |
| 9 | 181797 | 6.7% |
| b | 180619 | 6.6% |
| 1 | 164127 | 6.0% |
| 2 | 163027 | 6.0% |
| d | 159905 | 5.9% |
| 3 | 159749 | 5.9% |
| 5 | 158988 | 5.8% |
| Other values (6) | 941560 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2718368 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 242452 | 8.9% |
| 8 | 183508 | 6.8% |
| a | 182636 | 6.7% |
| 9 | 181797 | 6.7% |
| b | 180619 | 6.6% |
| 1 | 164127 | 6.0% |
| 2 | 163027 | 6.0% |
| d | 159905 | 5.9% |
| 3 | 159749 | 5.9% |
| 5 | 158988 | 5.8% |
| Other values (6) | 941560 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 57089 | |
| 1 | 27860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 57089 | |
| 1 | 27860 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 57089 | |
| 1 | 27860 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 57089 | |
| 1 | 27860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 57089 | |
| 1 | 27860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 57089 | |
| 1 | 27860 |
graphic_design
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| B | |
|---|---|
| A | |
| C |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | B |
| 3rd row | C |
| 4th row | A |
| 5th row | B |
Common Values
| Value | Count | Frequency (%) |
| B | 34114 | |
| A | 33890 | |
| C | 16945 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 34114 | |
| a | 33890 | |
| c | 16945 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 34114 | |
| A | 33890 | |
| C | 16945 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 34114 | |
| A | 33890 | |
| C | 16945 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 34114 | |
| A | 33890 | |
| C | 16945 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 34114 | |
| A | 33890 | |
| C | 16945 |
top_1_section
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 3 | |
|---|---|
| 4 | |
| 1 | |
| 6 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 6 |
|---|---|
| 2nd row | 4 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 42453 | |
| 4 | 17122 | |
| 1 | 16956 | 20.0% |
| 6 | 8418 | 9.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 42453 | |
| 4 | 17122 | |
| 1 | 16956 | 20.0% |
| 6 | 8418 | 9.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 42453 | |
| 4 | 17122 | |
| 1 | 16956 | 20.0% |
| 6 | 8418 | 9.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 42453 | |
| 4 | 17122 | |
| 1 | 16956 | 20.0% |
| 6 | 8418 | 9.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 42453 | |
| 4 | 17122 | |
| 1 | 16956 | 20.0% |
| 6 | 8418 | 9.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84949 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 42453 | |
| 4 | 17122 | |
| 1 | 16956 | 20.0% |
| 6 | 8418 | 9.9% |
top_2_section
Real number (ℝ)
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4024532 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.4980915 |
|---|---|
| Coefficient of variation (CV) | 0.44029744 |
| Kurtosis | -1.0131755 |
| Mean | 3.4024532 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.19027042 |
| Sum | 289035 |
| Variance | 2.244278 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 25436 | |
| 5 | 17048 | |
| 2 | 16947 | |
| 6 | 8527 | 10.0% |
| 1 | 8511 | 10.0% |
| 4 | 8480 | 10.0% |
| Value | Count | Frequency (%) |
| 1 | 8511 | 10.0% |
| 2 | 16947 | |
| 3 | 25436 | |
| 4 | 8480 | 10.0% |
| 5 | 17048 | |
| 6 | 8527 | 10.0% |
| Value | Count | Frequency (%) |
| 6 | 8527 | 10.0% |
| 5 | 17048 | |
| 4 | 8480 | 10.0% |
| 3 | 25436 | |
| 2 | 16947 | |
| 1 | 8511 | 10.0% |
top_3_section
Real number (ℝ)
High correlation  Zeros 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5058211 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 16945 |
| Zeros (%) | 19.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 663.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.7466911 |
|---|---|
| Coefficient of variation (CV) | 0.69705336 |
| Kurtosis | -1.2086607 |
| Mean | 2.5058211 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.0051259014 |
| Sum | 212867 |
| Variance | 3.0509296 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 17066 | |
| 3 | 17060 | |
| 0 | 16945 | |
| 2 | 16943 | |
| 4 | 8512 | |
| 1 | 8423 |
| Value | Count | Frequency (%) |
| 0 | 16945 | |
| 1 | 8423 | |
| 2 | 16943 | |
| 3 | 17060 | |
| 4 | 8512 | |
| 5 | 17066 |
| Value | Count | Frequency (%) |
| 5 | 17066 | |
| 4 | 8512 | |
| 3 | 17060 | |
| 2 | 16943 | |
| 1 | 8423 | |
| 0 | 16945 |
Interactions
Correlations
| booking_adult_count | booking_child_count | booking_id | booking_infant_count | booking_leg_count | booking_original_currency | booking_pax_count | booking_payment_method | booking_reservation_month | booking_sales_channel | booking_segments_count | booking_trip_type | booking_window_w | clicked | coupon_cabin_class | coupon_marketing_flight_number | coupon_miles | coupon_number | coupon_range | coupon_rbd_code | flight_coupon_id | flight_leg_id | graphic_design | id | is_seat | leg_arrival_hour | leg_departure_hour | leg_departure_month | leg_destination_country_code | leg_duration_h | leg_first_leg_flg | leg_hours_to_departure | leg_last_leg_flg | leg_number | leg_origin_country_code | leg_stopover_time_h | preffered_language | top_1_section | top_2_section | top_3_section | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| booking_adult_count | 1.000 | 0.168 | -0.004 | 0.117 | 0.014 | 0.000 | 0.956 | 0.072 | -0.074 | 0.093 | 0.049 | 0.023 | 0.231 | 0.001 | 0.000 | -0.007 | 0.076 | 0.029 | 0.003 | 0.356 | -0.001 | -0.005 | 0.005 | -0.035 | 0.052 | -0.017 | -0.013 | -0.008 | 0.021 | 0.044 | 0.011 | 0.004 | 0.011 | 0.006 | 0.000 | 0.033 | 0.023 | 0.000 | 0.003 | 0.003 |
| booking_child_count | 0.168 | 1.000 | -0.005 | 0.077 | 0.019 | 0.015 | 0.375 | 0.015 | -0.010 | 0.026 | 0.021 | 0.029 | 0.073 | 0.024 | 0.004 | -0.013 | 0.049 | 0.023 | 0.008 | 0.010 | -0.003 | 0.005 | 0.003 | 0.028 | 0.008 | 0.010 | -0.010 | 0.004 | 0.031 | 0.022 | 0.018 | -0.001 | 0.013 | 0.021 | 0.028 | 0.021 | 0.027 | 0.004 | 0.003 | 0.007 |
| booking_id | -0.004 | -0.005 | 1.000 | 0.006 | 0.003 | 0.000 | -0.004 | 0.000 | 0.000 | 0.003 | -0.000 | 0.000 | -0.001 | 0.007 | 0.003 | -0.000 | -0.002 | -0.003 | 0.000 | 0.001 | -0.005 | 0.004 | 0.000 | -0.006 | 0.000 | -0.003 | 0.002 | 0.005 | 0.003 | 0.004 | 0.000 | -0.001 | 0.006 | 0.002 | 0.003 | -0.002 | 0.002 | 0.004 | -0.000 | -0.002 |
| booking_infant_count | 0.117 | 0.077 | 0.006 | 1.000 | 0.042 | 0.000 | 0.121 | 0.006 | 0.013 | 0.027 | 0.000 | 0.007 | 0.009 | 0.028 | 0.000 | 0.011 | 0.005 | 0.005 | 0.000 | 0.033 | 0.004 | 0.000 | 0.000 | 0.009 | 0.015 | 0.009 | 0.011 | 0.005 | 0.031 | 0.012 | 0.011 | 0.006 | 0.000 | 0.020 | 0.009 | 0.000 | 0.003 | 0.000 | 0.001 | 0.004 |
| booking_leg_count | 0.014 | 0.019 | 0.003 | 0.042 | 1.000 | 0.111 | 0.014 | 0.033 | 0.054 | 0.069 | 0.444 | 0.697 | 0.062 | 0.010 | 0.031 | 0.033 | 0.071 | 0.171 | 0.068 | 0.130 | 0.005 | 0.005 | 0.004 | 0.024 | 0.050 | 0.034 | 0.048 | 0.021 | 0.071 | 0.074 | 0.464 | 0.073 | 0.459 | 0.482 | 0.134 | 0.265 | 0.129 | 0.006 | 0.004 | 0.005 |
| booking_original_currency | 0.000 | 0.015 | 0.000 | 0.000 | 0.111 | 1.000 | 0.007 | 0.245 | 0.050 | 0.283 | 0.127 | 0.149 | 0.043 | 0.068 | 0.142 | 0.147 | 0.349 | 0.086 | 0.322 | 0.055 | 0.009 | 0.005 | 0.010 | 0.045 | 0.162 | 0.127 | 0.182 | 0.054 | 0.179 | 0.168 | 0.079 | 0.265 | 0.077 | 0.075 | 0.231 | 0.068 | 0.592 | 0.000 | 0.005 | 0.010 |
| booking_pax_count | 0.956 | 0.375 | -0.004 | 0.121 | 0.014 | 0.007 | 1.000 | 0.070 | -0.071 | 0.090 | 0.048 | 0.022 | 0.232 | 0.004 | 0.000 | -0.010 | 0.082 | 0.032 | 0.005 | 0.338 | -0.002 | -0.003 | 0.007 | -0.030 | 0.050 | -0.014 | -0.015 | -0.006 | 0.022 | 0.045 | 0.009 | 0.004 | 0.011 | 0.008 | 0.012 | 0.035 | 0.022 | 0.000 | 0.005 | 0.004 |
| booking_payment_method | 0.072 | 0.015 | 0.000 | 0.006 | 0.033 | 0.245 | 0.070 | 1.000 | 0.062 | 0.137 | 0.028 | 0.037 | 0.064 | 0.019 | 0.023 | 0.026 | 0.066 | 0.031 | 0.065 | 0.125 | 0.000 | 0.000 | 0.005 | 0.021 | 0.053 | 0.041 | 0.049 | 0.016 | 0.114 | 0.058 | 0.022 | 0.060 | 0.020 | 0.034 | 0.116 | 0.015 | 0.087 | 0.000 | 0.003 | 0.000 |
| booking_reservation_month | -0.074 | -0.010 | 0.000 | 0.013 | 0.054 | 0.050 | -0.071 | 0.062 | 1.000 | 0.041 | -0.022 | 0.084 | -0.246 | 0.074 | 0.042 | 0.014 | -0.106 | -0.047 | 0.108 | 0.059 | 0.001 | 0.000 | 0.000 | 0.153 | 0.022 | 0.011 | -0.023 | 0.528 | 0.074 | -0.051 | 0.044 | 0.040 | 0.043 | 0.091 | 0.081 | -0.051 | 0.082 | 0.000 | -0.003 | 0.001 |
| booking_sales_channel | 0.093 | 0.026 | 0.003 | 0.027 | 0.069 | 0.283 | 0.090 | 0.137 | 0.041 | 1.000 | 0.046 | 0.095 | 0.049 | 0.029 | 0.066 | 0.020 | 0.060 | 0.026 | 0.066 | 0.300 | 0.003 | 0.006 | 0.000 | 0.020 | 0.087 | 0.021 | 0.039 | 0.018 | 0.100 | 0.045 | 0.055 | 0.043 | 0.051 | 0.043 | 0.087 | 0.030 | 0.348 | 0.000 | 0.001 | 0.000 |
| booking_segments_count | 0.049 | 0.021 | -0.000 | 0.000 | 0.444 | 0.127 | 0.048 | 0.028 | -0.022 | 0.046 | 1.000 | 0.630 | 0.055 | 0.019 | 0.023 | -0.020 | -0.019 | 0.498 | 0.062 | 0.067 | 0.001 | 0.002 | 0.005 | 0.047 | 0.095 | -0.014 | -0.060 | -0.003 | 0.078 | 0.443 | 0.350 | 0.090 | 0.344 | 0.245 | 0.114 | 0.298 | 0.171 | 0.003 | 0.002 | -0.003 |
| booking_trip_type | 0.023 | 0.029 | 0.000 | 0.007 | 0.697 | 0.149 | 0.022 | 0.037 | 0.084 | 0.095 | 0.630 | 1.000 | 0.100 | 0.015 | 0.039 | 0.039 | 0.095 | 0.220 | 0.089 | 0.174 | 0.004 | 0.004 | 0.000 | 0.069 | 0.042 | 0.048 | 0.061 | 0.064 | 0.098 | 0.082 | 0.446 | 0.081 | 0.441 | 0.293 | 0.153 | 0.312 | 0.144 | 0.003 | 0.003 | 0.000 |
| booking_window_w | 0.231 | 0.073 | -0.001 | 0.009 | 0.062 | 0.043 | 0.232 | 0.064 | -0.246 | 0.049 | 0.055 | 0.100 | 1.000 | 0.059 | 0.073 | -0.022 | 0.163 | 0.026 | 0.114 | 0.103 | 0.001 | 0.005 | 0.000 | -0.105 | 0.035 | -0.016 | 0.031 | 0.018 | 0.076 | 0.101 | 0.050 | -0.054 | 0.051 | 0.049 | 0.064 | 0.080 | 0.112 | 0.004 | 0.000 | -0.002 |
| clicked | 0.001 | 0.024 | 0.007 | 0.028 | 0.010 | 0.068 | 0.004 | 0.019 | 0.074 | 0.029 | 0.019 | 0.015 | 0.059 | 1.000 | 0.035 | 0.021 | 0.077 | 0.012 | 0.076 | 0.036 | 0.000 | 0.000 | 0.000 | 0.077 | 0.000 | 0.034 | 0.049 | 0.070 | 0.064 | 0.066 | 0.000 | 0.066 | 0.006 | 0.013 | 0.094 | 0.006 | 0.004 | 0.000 | 0.006 | 0.008 |
| coupon_cabin_class | 0.000 | 0.004 | 0.003 | 0.000 | 0.031 | 0.142 | 0.000 | 0.023 | 0.042 | 0.066 | 0.023 | 0.039 | 0.073 | 0.035 | 1.000 | 0.064 | 0.237 | 0.016 | 0.233 | 0.998 | 0.005 | 0.001 | 0.000 | 0.025 | 0.149 | 0.060 | 0.088 | 0.023 | 0.162 | 0.130 | 0.016 | 0.135 | 0.012 | 0.026 | 0.153 | 0.030 | 0.012 | 0.006 | 0.000 | 0.000 |
| coupon_marketing_flight_number | -0.007 | -0.013 | -0.000 | 0.011 | 0.033 | 0.147 | -0.010 | 0.026 | 0.014 | 0.020 | -0.020 | 0.039 | -0.022 | 0.021 | 0.064 | 1.000 | -0.175 | -0.043 | 0.149 | 0.035 | -0.000 | -0.003 | 0.006 | 0.020 | 0.026 | -0.032 | 0.063 | 0.001 | 0.423 | -0.084 | 0.025 | -0.014 | 0.023 | 0.043 | 0.396 | -0.030 | 0.026 | 0.008 | -0.003 | 0.008 |
| coupon_miles | 0.076 | 0.049 | -0.002 | 0.005 | 0.071 | 0.349 | 0.082 | 0.066 | -0.106 | 0.060 | -0.019 | 0.095 | 0.163 | 0.077 | 0.237 | -0.175 | 1.000 | 0.055 | 0.586 | 0.141 | -0.004 | 0.001 | 0.008 | -0.064 | 0.135 | -0.029 | 0.154 | -0.035 | 0.557 | 0.470 | 0.058 | -0.188 | 0.055 | 0.080 | 0.495 | 0.126 | 0.045 | 0.005 | 0.003 | -0.005 |
| coupon_number | 0.029 | 0.023 | -0.003 | 0.005 | 0.171 | 0.086 | 0.032 | 0.031 | -0.047 | 0.026 | 0.498 | 0.220 | 0.026 | 0.012 | 0.016 | -0.043 | 0.055 | 1.000 | 0.051 | 0.036 | 0.000 | 0.006 | 0.006 | -0.001 | 0.049 | 0.107 | 0.066 | -0.010 | 0.223 | 0.245 | 0.137 | 0.090 | 0.126 | 0.566 | 0.263 | 0.151 | 0.108 | 0.003 | 0.003 | -0.007 |
| coupon_range | 0.003 | 0.008 | 0.000 | 0.000 | 0.068 | 0.322 | 0.005 | 0.065 | 0.108 | 0.066 | 0.062 | 0.089 | 0.114 | 0.076 | 0.233 | 0.149 | 0.586 | 0.051 | 1.000 | 0.153 | 0.000 | 0.000 | 0.004 | 0.060 | 0.074 | 0.142 | 0.231 | 0.058 | 0.446 | 0.330 | 0.057 | 0.326 | 0.053 | 0.075 | 0.398 | 0.090 | 0.000 | 0.003 | 0.002 | 0.002 |
| coupon_rbd_code | 0.356 | 0.010 | 0.001 | 0.033 | 0.130 | 0.055 | 0.338 | 0.125 | 0.059 | 0.300 | 0.067 | 0.174 | 0.103 | 0.036 | 0.998 | 0.035 | 0.141 | 0.036 | 0.153 | 1.000 | 0.000 | 0.009 | 0.000 | 0.056 | 0.202 | 0.041 | 0.050 | 0.072 | 0.068 | 0.075 | 0.105 | 0.084 | 0.097 | 0.078 | 0.074 | 0.050 | 0.135 | 0.000 | 0.000 | 0.000 |
| flight_coupon_id | -0.001 | -0.003 | -0.005 | 0.004 | 0.005 | 0.009 | -0.002 | 0.000 | 0.001 | 0.003 | 0.001 | 0.004 | 0.001 | 0.000 | 0.005 | -0.000 | -0.004 | 0.000 | 0.000 | 0.000 | 1.000 | -0.005 | 0.000 | -0.004 | 0.009 | -0.004 | -0.005 | -0.001 | 0.000 | 0.004 | 0.013 | -0.000 | 0.011 | 0.000 | 0.008 | -0.000 | 0.005 | 0.004 | -0.001 | 0.003 |
| flight_leg_id | -0.005 | 0.005 | 0.004 | 0.000 | 0.005 | 0.005 | -0.003 | 0.000 | 0.000 | 0.006 | 0.002 | 0.004 | 0.005 | 0.000 | 0.001 | -0.003 | 0.001 | 0.006 | 0.000 | 0.009 | -0.005 | 1.000 | 0.002 | -0.001 | 0.000 | -0.004 | -0.001 | -0.003 | 0.003 | 0.008 | 0.003 | -0.004 | 0.000 | 0.000 | 0.010 | -0.001 | 0.000 | 0.000 | -0.005 | -0.002 |
| graphic_design | 0.005 | 0.003 | 0.000 | 0.000 | 0.004 | 0.010 | 0.007 | 0.005 | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.000 | 0.006 | 0.008 | 0.006 | 0.004 | 0.000 | 0.000 | 0.002 | 1.000 | 0.005 | 0.000 | 0.007 | 0.000 | 0.006 | 0.009 | 0.000 | 0.005 | 0.004 | 0.001 | 0.005 | 0.000 | 0.000 | 0.000 | 0.707 | 0.817 | 0.935 |
| id | -0.035 | 0.028 | -0.006 | 0.009 | 0.024 | 0.045 | -0.030 | 0.021 | 0.153 | 0.020 | 0.047 | 0.069 | -0.105 | 0.077 | 0.025 | 0.020 | -0.064 | -0.001 | 0.060 | 0.056 | -0.004 | -0.001 | 0.005 | 1.000 | 0.026 | 0.050 | 0.001 | -0.001 | 0.074 | -0.009 | 0.017 | 0.031 | 0.015 | 0.038 | 0.075 | -0.001 | 0.037 | 0.001 | -0.001 | 0.006 |
| is_seat | 0.052 | 0.008 | 0.000 | 0.015 | 0.050 | 0.162 | 0.050 | 0.053 | 0.022 | 0.087 | 0.095 | 0.042 | 0.035 | 0.000 | 0.149 | 0.026 | 0.135 | 0.049 | 0.074 | 0.202 | 0.009 | 0.000 | 0.000 | 0.026 | 1.000 | 0.053 | 0.079 | 0.025 | 0.148 | 0.065 | 0.020 | 0.074 | 0.023 | 0.012 | 0.157 | 0.034 | 0.022 | 0.000 | 0.000 | 0.002 |
| leg_arrival_hour | -0.017 | 0.010 | -0.003 | 0.009 | 0.034 | 0.127 | -0.014 | 0.041 | 0.011 | 0.021 | -0.014 | 0.048 | -0.016 | 0.034 | 0.060 | -0.032 | -0.029 | 0.107 | 0.142 | 0.041 | -0.004 | -0.004 | 0.007 | 0.050 | 0.053 | 1.000 | 0.439 | 0.003 | 0.456 | -0.133 | 0.028 | 0.054 | 0.024 | 0.113 | 0.341 | -0.013 | 0.075 | 0.000 | -0.002 | -0.007 |
| leg_departure_hour | -0.013 | -0.010 | 0.002 | 0.011 | 0.048 | 0.182 | -0.015 | 0.049 | -0.023 | 0.039 | -0.060 | 0.061 | 0.031 | 0.049 | 0.088 | 0.063 | 0.154 | 0.066 | 0.231 | 0.050 | -0.005 | -0.001 | 0.000 | 0.001 | 0.079 | 0.439 | 1.000 | 0.006 | 0.330 | 0.120 | 0.038 | -0.302 | 0.037 | 0.135 | 0.427 | 0.045 | 0.071 | 0.003 | 0.001 | -0.004 |
| leg_departure_month | -0.008 | 0.004 | 0.005 | 0.005 | 0.021 | 0.054 | -0.006 | 0.016 | 0.528 | 0.018 | -0.003 | 0.064 | 0.018 | 0.070 | 0.023 | 0.001 | -0.035 | -0.010 | 0.058 | 0.072 | -0.001 | -0.003 | 0.006 | -0.001 | 0.025 | 0.003 | 0.006 | 1.000 | 0.090 | -0.014 | 0.018 | -0.009 | 0.014 | 0.029 | 0.093 | -0.010 | 0.036 | 0.005 | 0.001 | 0.004 |
| leg_destination_country_code | 0.021 | 0.031 | 0.003 | 0.031 | 0.071 | 0.179 | 0.022 | 0.114 | 0.074 | 0.100 | 0.078 | 0.098 | 0.076 | 0.064 | 0.162 | 0.423 | 0.557 | 0.223 | 0.446 | 0.068 | 0.000 | 0.003 | 0.009 | 0.074 | 0.148 | 0.456 | 0.330 | 0.090 | 1.000 | 0.406 | 0.032 | 0.158 | 0.051 | 0.391 | 0.142 | 0.049 | 0.559 | 0.018 | 0.013 | 0.013 |
| leg_duration_h | 0.044 | 0.022 | 0.004 | 0.012 | 0.074 | 0.168 | 0.045 | 0.058 | -0.051 | 0.045 | 0.443 | 0.082 | 0.101 | 0.066 | 0.130 | -0.084 | 0.470 | 0.245 | 0.330 | 0.075 | 0.004 | 0.008 | 0.000 | -0.009 | 0.065 | -0.133 | 0.120 | -0.014 | 0.406 | 1.000 | 0.046 | -0.210 | 0.043 | 0.072 | 0.351 | 0.076 | 0.145 | 0.000 | -0.002 | -0.003 |
| leg_first_leg_flg | 0.011 | 0.018 | 0.000 | 0.011 | 0.464 | 0.079 | 0.009 | 0.022 | 0.044 | 0.055 | 0.350 | 0.446 | 0.050 | 0.000 | 0.016 | 0.025 | 0.058 | 0.137 | 0.057 | 0.105 | 0.013 | 0.003 | 0.005 | 0.017 | 0.020 | 0.028 | 0.038 | 0.018 | 0.032 | 0.046 | 1.000 | 0.052 | 0.572 | 0.197 | 0.059 | 0.572 | 0.057 | 0.008 | 0.010 | 0.000 |
| leg_hours_to_departure | 0.004 | -0.001 | -0.001 | 0.006 | 0.073 | 0.265 | 0.004 | 0.060 | 0.040 | 0.043 | 0.090 | 0.081 | -0.054 | 0.066 | 0.135 | -0.014 | -0.188 | 0.090 | 0.326 | 0.084 | -0.000 | -0.004 | 0.004 | 0.031 | 0.074 | 0.054 | -0.302 | -0.009 | 0.158 | -0.210 | 0.052 | 1.000 | 0.052 | 0.101 | 0.733 | -0.058 | 0.052 | 0.006 | -0.001 | -0.004 |
| leg_last_leg_flg | 0.011 | 0.013 | 0.006 | 0.000 | 0.459 | 0.077 | 0.011 | 0.020 | 0.043 | 0.051 | 0.344 | 0.441 | 0.051 | 0.006 | 0.012 | 0.023 | 0.055 | 0.126 | 0.053 | 0.097 | 0.011 | 0.000 | 0.001 | 0.015 | 0.023 | 0.024 | 0.037 | 0.014 | 0.051 | 0.043 | 0.572 | 0.052 | 1.000 | 0.189 | 0.077 | 1.000 | 0.058 | 0.000 | 0.000 | 0.000 |
| leg_number | 0.006 | 0.021 | 0.002 | 0.020 | 0.482 | 0.075 | 0.008 | 0.034 | 0.091 | 0.043 | 0.245 | 0.293 | 0.049 | 0.013 | 0.026 | 0.043 | 0.080 | 0.566 | 0.075 | 0.078 | 0.000 | 0.000 | 0.005 | 0.038 | 0.012 | 0.113 | 0.135 | 0.029 | 0.391 | 0.072 | 0.197 | 0.101 | 0.189 | 1.000 | 0.418 | 0.136 | 0.049 | 0.000 | 0.006 | 0.005 |
| leg_origin_country_code | 0.000 | 0.028 | 0.003 | 0.009 | 0.134 | 0.231 | 0.012 | 0.116 | 0.081 | 0.087 | 0.114 | 0.153 | 0.064 | 0.094 | 0.153 | 0.396 | 0.495 | 0.263 | 0.398 | 0.074 | 0.008 | 0.010 | 0.000 | 0.075 | 0.157 | 0.341 | 0.427 | 0.093 | 0.142 | 0.351 | 0.059 | 0.733 | 0.077 | 0.418 | 1.000 | 0.051 | 0.581 | 0.000 | 0.000 | 0.000 |
| leg_stopover_time_h | 0.033 | 0.021 | -0.002 | 0.000 | 0.265 | 0.068 | 0.035 | 0.015 | -0.051 | 0.030 | 0.298 | 0.312 | 0.080 | 0.006 | 0.030 | -0.030 | 0.126 | 0.151 | 0.090 | 0.050 | -0.000 | -0.001 | 0.000 | -0.001 | 0.034 | -0.013 | 0.045 | -0.010 | 0.049 | 0.076 | 0.572 | -0.058 | 1.000 | 0.136 | 0.051 | 1.000 | 0.064 | 0.000 | 0.000 | -0.004 |
| preffered_language | 0.023 | 0.027 | 0.002 | 0.003 | 0.129 | 0.592 | 0.022 | 0.087 | 0.082 | 0.348 | 0.171 | 0.144 | 0.112 | 0.004 | 0.012 | 0.026 | 0.045 | 0.108 | 0.000 | 0.135 | 0.005 | 0.000 | 0.000 | 0.037 | 0.022 | 0.075 | 0.071 | 0.036 | 0.559 | 0.145 | 0.057 | 0.052 | 0.058 | 0.049 | 0.581 | 0.064 | 1.000 | 0.000 | 0.000 | 0.000 |
| top_1_section | 0.000 | 0.004 | 0.004 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.003 | 0.004 | 0.000 | 0.006 | 0.008 | 0.005 | 0.003 | 0.003 | 0.000 | 0.004 | 0.000 | 0.707 | 0.001 | 0.000 | 0.000 | 0.003 | 0.005 | 0.018 | 0.000 | 0.008 | 0.006 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.568 | 0.632 |
| top_2_section | 0.003 | 0.003 | -0.000 | 0.001 | 0.004 | 0.005 | 0.005 | 0.003 | -0.003 | 0.001 | 0.002 | 0.003 | 0.000 | 0.006 | 0.000 | -0.003 | 0.003 | 0.003 | 0.002 | 0.000 | -0.001 | -0.005 | 0.817 | -0.001 | 0.000 | -0.002 | 0.001 | 0.001 | 0.013 | -0.002 | 0.010 | -0.001 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 | 0.568 | 1.000 | 0.098 |
| top_3_section | 0.003 | 0.007 | -0.002 | 0.004 | 0.005 | 0.010 | 0.004 | 0.000 | 0.001 | 0.000 | -0.003 | 0.000 | -0.002 | 0.008 | 0.000 | 0.008 | -0.005 | -0.007 | 0.002 | 0.000 | 0.003 | -0.002 | 0.935 | 0.006 | 0.002 | -0.007 | -0.004 | 0.004 | 0.013 | -0.003 | 0.000 | -0.004 | 0.000 | 0.005 | 0.000 | -0.004 | 0.000 | 0.632 | 0.098 | 1.000 |
Missing values
Sample
| id | booking_adult_count | booking_child_count | booking_destination_airport_code | booking_id | booking_infant_count | booking_leg_count | booking_market | booking_origin_airport_code | booking_original_currency | booking_pax_count | booking_payment_method | booking_reservation_month | booking_sales_channel | booking_segments_count | booking_trip_type | booking_window_w | coupon_cabin_class | coupon_destination_airport_code | coupon_fare_basis | coupon_marketing_flight_number | coupon_miles | coupon_number | coupon_origin_airport_code | coupon_range | coupon_rbd_code | flight_coupon_id | flight_leg_id | is_seat | leg_arrival_hour | leg_arrival_timezone_code | leg_departure_hour | leg_departure_month | leg_departure_timezone_code | leg_destination_airport_code | leg_destination_country_code | leg_duration_h | leg_first_leg_flg | leg_hours_to_departure | leg_last_leg_flg | leg_number | leg_origin_airport_code | leg_origin_country_code | leg_stopover_time_h | pnr | preffered_language | request_dttm | request_id | clicked | graphic_design | top_1_section | top_2_section | top_3_section | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 105529 | 1 | 0 | TBS | 6386840 | 0 | 2 | GE | WAW | GEL | 1 | 95582540167d4ebb9497a7031f046757 | 1 | website | 2 | RT | 4 | economy | WAW | ee702af56c9f42c49677ede02047afcd | 8102495 | 1334 | 2 | TBS | SH | b6460aef6f204ba8940329aa9f7f99cd | 4a0d5a2fe1974c1f8e8082afa8bdd72b | 7604138 | 1585907 | 0 | 6 | Europe/Warsaw | 5 | 2 | Asia/Tbilisi | WAW | NaN | 0 | 1 | 74 | 0 | 2 | TBS | NaN | 365 | 40faefe514be47b38cea3be065583d7f | en_gb | 2014-03-02T21:13:05.030Z | ee37548ce2a74b99b41d67f4d2a138fd | 0 | C | 6 | 3 | 0 |
| 1 | 28386 | 1 | 0 | WAW | 6842736 | 0 | 2 | US | EWR | USD | 1 | 95582540167d4ebb9497a7031f046757 | 8 | website | 2 | RT | 2 | economy | EWR | 64e30cc1470248f6896a74d5774954b8 | 3391275 | 4268 | 2 | WAW | LH | 5b4d18c017084084b2c8e3860625237e | eb3f322048494f7ea59d63bb636772c8 | 1440297 | 8701111 | 1 | 20 | America/New_York | 17 | 9 | Europe/Warsaw | EWR | US | 3 | 1 | 71 | 0 | 2 | WAW | NaN | 325 | 7fafefddde544aba95c69552cfbadd51 | en_gb | 2013-10-09T11:08:14.112Z | f083457969dd46d2ada761198096ecc4 | 1 | B | 4 | 3 | 5 |
| 2 | 107663 | 1 | 0 | BEG | 3164316 | 0 | 2 | PL | SZZ | NaN | 1 | 1bb2b25a099d4a438425d276203a0c2c | 2 | website | 4 | RT | 0 | economy | WAW | 76c8fafae85c47e0849a2b85b23dce08 | 1303546 | 507 | 3 | BEG | SH | fcd7f2fe3e034355bcc3fff350b5c928 | 93fe4d004f074298ae540784f5466926 | 8864878 | 2564724 | 0 | 20 | Europe/Warsaw | 13 | 2 | Europe/Belgrade | SZZ | NaN | 6 | 0 | 71 | 1 | 2 | BEG | NaN | -9999 | 6240c081718e4439a3174ac38a2c9c45 | en_gb | 2014-03-08T08:15:38.344Z | 9df9a894f4374dfba0d8811dd99c1b1e | 0 | C | 3 | 6 | 0 |
| 3 | 24881 | 1 | 0 | BOM | 3835074 | 0 | 1 | SE | WAW | NaN | 1 | 1bb2b25a099d4a438425d276203a0c2c | 9 | agents | 1 | OW | 0 | economy | BOM | 9915e38b5cf247588f6f4ae680b53f5e | 2394395 | 3591 | 1 | WAW | LH | 06461e5ef0bb4941995dadba33f4b58a | a9a8894fee5d44da923224e46a280e9c | 4806814 | 6460284 | 0 | 2 | Asia/Kolkata | 15 | 9 | Europe/Warsaw | BOM | NaN | 11 | 1 | 71 | 1 | 1 | WAW | NaN | -9999 | 231c99e3d0644366827e91276296e3cc | en_gb | 2013-10-06T09:09:48.597Z | 89c95fa040db42d4a1982c7901128585 | 1 | A | 3 | 1 | 2 |
| 4 | 90383 | 1 | 0 | OTP | 5962948 | 0 | 2 | PL | OSL | PLN | 1 | 95582540167d4ebb9497a7031f046757 | 10 | agents | 4 | RT | 9 | economy | WAW | 0b93a67a450640c19f68cd8e77464ffa | 8788690 | 671 | 1 | OSL | SH | fcd7f2fe3e034355bcc3fff350b5c928 | 7e7a981bfcff46aa9077f2dd2803ac57 | 2708982 | 9204582 | 0 | 1 | Europe/Bucharest | 19 | 12 | Europe/Oslo | OTP | NaN | 5 | 1 | 71 | 0 | 1 | OSL | NaN | 249 | 4854301527cf48f7a32c9625a154874b | en_gb | 2014-01-07T14:14:06.568Z | d44b65a240374e61867039b37c98f9a0 | 1 | B | 3 | 4 | 5 |
| 5 | 37616 | 1 | 0 | JFK | 4772021 | 0 | 2 | PL | WAW | PLN | 1 | 95582540167d4ebb9497a7031f046757 | 8 | agents | 2 | RT | 5 | premium | WAW | 7be28cf8c9c748ba81b3be6abf5132dd | 7648128 | 4255 | 2 | JFK | LH | b594ecdd148e4893a8be54afc5783eb7 | 560894c6149647e0b43ad23fb95ced87 | 2805853 | 5023742 | 1 | 13 | Europe/Warsaw | 22 | 10 | America/New_York | WAW | NaN | 14 | 0 | 65 | 1 | 2 | JFK | NaN | -9999 | d6d7da1536074ab9a2df8a3575c90e0a | en_gb | 2013-10-18T22:04:46.740Z | f6d1903c1ff24372932b8410c35afc09 | 0 | B | 4 | 3 | 5 |
| 6 | 30135 | 2 | 0 | BCN | 7868365 | 0 | 2 | PL | WAW | PLN | 2 | 95582540167d4ebb9497a7031f046757 | 7 | website | 2 | RT | 9 | economy | WAW | 827044bc992241a7a6e0a821d48d6967 | 7174818 | 1162 | 2 | BCN | SH | 5b4d18c017084084b2c8e3860625237e | 12e3c755b9d9443dbd2ba1b182716f69 | 8578738 | 9799232 | 0 | 16 | Europe/Warsaw | 13 | 9 | Europe/Madrid | WAW | PL | 3 | 0 | 71 | 1 | 2 | BCN | ES | -9999 | e7352d3377f84d2ab8c3c103e849109e | pl_pl | 2013-10-11T07:07:08.502Z | a9e4f2e6e9454e22ad5f8211a31179a7 | 1 | A | 3 | 2 | 1 |
| 7 | 45344 | 1 | 0 | LCY | 4155457 | 0 | 2 | PL | VNO | PLN | 1 | 95582540167d4ebb9497a7031f046757 | 9 | website | 2 | RT | 3 | economy | VNO | 2e3e48530fc94e3d8f178a76955d9e5c | 8072518 | 1063 | 2 | LCY | SH | 06461e5ef0bb4941995dadba33f4b58a | af25bbb58076464db7c8c4bdaccdf8fb | 3599594 | 5980874 | 0 | 23 | Europe/Vilnius | 18 | 10 | Europe/London | VNO | NaN | 4 | 1 | 70 | 0 | 2 | LCY | NaN | 123 | 59ebc18b9d8f41ed8ed00db422b2159c | en_gb | 2013-10-26T13:11:21.909Z | e825ceb099a64eeba27ff931a38c4aba | 0 | A | 1 | 2 | 3 |
| 8 | 75045 | 1 | 0 | NaN | 8205418 | 0 | 2 | JP | NRT | JPY | 1 | 95582540167d4ebb9497a7031f046757 | 9 | website | 4 | MC | 10 | economy | PRG | 0cf08327bd024d58928a4437d3a0a4c0 | 4837468 | 323 | 2 | WAW | SH | 06461e5ef0bb4941995dadba33f4b58a | ea4df15d902e4438929a53c0bfa634aa | 9021794 | 1154898 | 0 | 17 | Europe/Prague | 23 | 11 | Asia/Tokyo | PRG | NaN | 18 | 0 | 78 | 1 | 1 | NRT | NaN | -9999 | 742662528ac141ada5e98c1a012b3c51 | en_gb | 2013-11-30T10:05:50.378Z | d8abd0a4e5c641b0951752e73b9e5ff6 | 0 | B | 3 | 5 | 4 |
| 9 | 22833 | 1 | 1 | WRO | 5740133 | 0 | 2 | KR | ICN | KRW | 2 | 95582540167d4ebb9497a7031f046757 | 9 | aiport_agents | 2 | RT | 2 | economy | WRO | 3e1b3ece53714b3096655cab2ac98bb7 | 6877925 | 4985 | 1 | ICN | LH | b6460aef6f204ba8940329aa9f7f99cd | be430c9c63154d81aa0ece356930e65e | 3829812 | 2549236 | 0 | 14 | Europe/Warsaw | 8 | 9 | Asia/Seoul | WRO | NaN | 6 | 1 | 78 | 0 | 1 | ICN | NaN | 1189 | 7c53d18a8ec743b392831e7d60db7a2f | en_gb | 2013-10-04T19:05:03.599Z | decb15efda654e89a9ae3b80bd51ff31 | 1 | B | 4 | 3 | 5 |
| id | booking_adult_count | booking_child_count | booking_destination_airport_code | booking_id | booking_infant_count | booking_leg_count | booking_market | booking_origin_airport_code | booking_original_currency | booking_pax_count | booking_payment_method | booking_reservation_month | booking_sales_channel | booking_segments_count | booking_trip_type | booking_window_w | coupon_cabin_class | coupon_destination_airport_code | coupon_fare_basis | coupon_marketing_flight_number | coupon_miles | coupon_number | coupon_origin_airport_code | coupon_range | coupon_rbd_code | flight_coupon_id | flight_leg_id | is_seat | leg_arrival_hour | leg_arrival_timezone_code | leg_departure_hour | leg_departure_month | leg_departure_timezone_code | leg_destination_airport_code | leg_destination_country_code | leg_duration_h | leg_first_leg_flg | leg_hours_to_departure | leg_last_leg_flg | leg_number | leg_origin_airport_code | leg_origin_country_code | leg_stopover_time_h | pnr | preffered_language | request_dttm | request_id | clicked | graphic_design | top_1_section | top_2_section | top_3_section | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84939 | 73819 | 1 | 0 | WAW | 6538636 | 0 | 2 | KR | ICN | KRW | 1 | 95582540167d4ebb9497a7031f046757 | 9 | agents | 2 | RT | 4 | economy | ICN | 9e49b681c5d2403d86e30d3d794bf793 | 4387324 | 4801 | 2 | WAW | LH | 5b4d18c017084084b2c8e3860625237e | e0afecb4e7954a2e87837602f6112fda | 7279220 | 5875102 | 0 | 7 | Asia/Seoul | 11 | 11 | Europe/Warsaw | ICN | NaN | 19 | 1 | 71 | 0 | 2 | WAW | NaN | 513 | 076f220f7b1a437e99a07a09a9884b70 | en_gb | 2013-11-29T06:06:50.242Z | 07ef4258276146cdb2ed7847cce9d238 | 0 | C | 3 | 6 | 0 |
| 84940 | 53876 | 4 | 0 | CDG | 2130240 | 0 | 2 | PL | WAW | PLN | 4 | 95582540167d4ebb9497a7031f046757 | 9 | internal_agents | 2 | RT | 5 | economy | CDG | 4dd0a4d3f47c4a9b966440cc2277b291 | 1156936 | 835 | 1 | WAW | SH | fcd7f2fe3e034355bcc3fff350b5c928 | 714c942b14dc451982a38ee32ee58992 | 2819062 | 1545899 | 0 | 9 | Europe/Paris | 7 | 10 | Europe/Warsaw | CDG | NaN | 2 | 1 | 71 | 0 | 1 | WAW | NaN | 52 | 8120eafc2a5142a285bcd3ea5466abf1 | en_gb | 2013-11-04T01:05:52.215Z | 8d50c38759df4077a7b942a83d85b88b | 0 | C | 3 | 6 | 0 |
| 84941 | 107921 | 1 | 0 | OSL | 7182852 | 0 | 1 | NO | OTP | NOK | 1 | 95582540167d4ebb9497a7031f046757 | 2 | agents | 2 | OW | 2 | economy | WAW | 9c1cc0d336174cb08dbcde11e420d2fa | 2567994 | 574 | 1 | OTP | SH | b6460aef6f204ba8940329aa9f7f99cd | 541890ff14dc43dea881d005f95a775e | 9118786 | 4226114 | 1 | 9 | Europe/Oslo | 5 | 2 | Europe/Bucharest | OSL | NaN | 4 | 1 | 72 | 1 | 1 | OTP | NaN | -9999 | bc4db3c451194b5aba3653b599c942e9 | en_gb | 2014-03-08T23:11:46.444Z | 255cd4653ff94b738dbae508f248e0d7 | 1 | C | 3 | 6 | 0 |
| 84942 | 45350 | 1 | 0 | DUS | 1303330 | 0 | 2 | PL | WAW | PLN | 1 | 95582540167d4ebb9497a7031f046757 | 5 | website | 2 | RT | 20 | economy | DUS | d576b543eb25443ba0540b652e0d31cb | 3519803 | 609 | 1 | WAW | SH | 5b4d18c017084084b2c8e3860625237e | 390bec66d9674f59b6a353ecd4eb2d87 | 7961879 | 4142908 | 0 | 22 | Europe/Berlin | 20 | 10 | Europe/Warsaw | DUS | DE | 1 | 1 | 70 | 0 | 1 | WAW | PL | 71 | e0542e2aa26443829200371053d8e000 | pl_pl | 2013-10-26T14:09:09.501Z | ae12b27dad79483a8bb9b833ffd08499 | 0 | C | 6 | 3 | 0 |
| 84943 | 101649 | 1 | 0 | VNO | 3895709 | 0 | 2 | GB | LCY | GBP | 1 | 95582540167d4ebb9497a7031f046757 | 1 | website | 2 | RT | 0 | economy | LCY | 3b59b3a71f574df286ca061a8b0b2022 | 7808418 | 1063 | 2 | VNO | SH | fcd7f2fe3e034355bcc3fff350b5c928 | 4f0877bc07214f6682c7ca1ebb7d5c43 | 6136100 | 4142373 | 0 | 18 | Europe/London | 17 | 2 | Europe/Vilnius | LCY | NaN | 1 | 1 | 72 | 0 | 2 | VNO | NaN | 93 | 183eebaf76cc4817a64e7e71e5cfafe9 | en_gb | 2014-02-19T10:12:15.277Z | c5811bca94314c5292f1128a28c61610 | 0 | C | 6 | 3 | 0 |
| 84944 | 7634 | 1 | 0 | WAW | 5494177 | 0 | 2 | US | EWR | USD | 1 | 95582540167d4ebb9497a7031f046757 | 7 | website | 2 | RT | 2 | economy | EWR | 29495f5a2b9245c6aa4fb92421cca708 | 4101912 | 4268 | 2 | WAW | LH | 22da46f1ddc1406e8e6aa78cdf573c16 | 3f8745c0a93e43bf923424000f6a1816 | 5087155 | 4135034 | 0 | 18 | America/New_York | 14 | 9 | Europe/Warsaw | EWR | US | 3 | 1 | 71 | 0 | 2 | WAW | PL | 710 | d86c510a2b114288bc6ca23cbdb20731 | pl_pl | 2013-09-21T08:09:47.626Z | c96bd1b541614661a3ec092f4594e5c1 | 1 | B | 4 | 3 | 5 |
| 84945 | 67152 | 1 | 0 | ICN | 4024574 | 0 | 2 | PL | WRO | PLN | 1 | 95582540167d4ebb9497a7031f046757 | 2 | website | 2 | RT | 36 | economy | ICN | 8a56b615f68b49dfac02202927f5dc52 | 7179801 | 4985 | 1 | WRO | LH | b6460aef6f204ba8940329aa9f7f99cd | 07d4a93a28ab4f85aa691f92b9c8f1c3 | 9436653 | 3291412 | 0 | 11 | Asia/Seoul | 16 | 11 | Europe/Warsaw | ICN | NaN | 19 | 1 | 71 | 0 | 1 | WRO | NaN | 1163 | 882f81dc62264d18be14b0c346249888 | en_gb | 2013-11-16T11:11:36.066Z | 22e4542ce44049da8a6f20ed6238faf0 | 1 | B | 3 | 4 | 5 |
| 84946 | 94614 | 2 | 0 | DEL | 9014936 | 0 | 2 | PL | WAW | PLN | 2 | 95582540167d4ebb9497a7031f046757 | 9 | website | 2 | RT | 15 | economy | WAW | 8d18c23df78e49318aae6e61dcfbbee3 | 5094257 | 3270 | 2 | DEL | LH | 5b4d18c017084084b2c8e3860625237e | fc67a620f82e45ecae47fef52fb0867a | 3181255 | 5838116 | 0 | 12 | Europe/Warsaw | 7 | 1 | Asia/Kolkata | WAW | PL | 4 | 1 | 75 | 0 | 2 | DEL | IN | 443 | 828a20846c724728ac8a0760efdf6df6 | pl_pl | 2014-01-27T22:12:08.965Z | 2532b32403f2417fb5717281ddadb9df | 1 | C | 3 | 6 | 0 |
| 84947 | 1031 | 2 | 0 | DBV | 5195800 | 0 | 2 | PL | WAW | PLN | 2 | 95582540167d4ebb9497a7031f046757 | 8 | website | 2 | RT | 3 | economy | WAW | 74e7a680e5b5456c803bc695ae1c5e8b | 4679285 | 674 | 2 | DBV | SH | fcd7f2fe3e034355bcc3fff350b5c928 | 976f2ce7602644fd8c39e2dc1250b9e0 | 7818370 | 7533678 | 1 | 21 | Europe/Warsaw | 19 | 8 | Europe/Zagreb | WAW | PL | 1 | 0 | 71 | 1 | 2 | DBV | HR | -9999 | 0e0f7bb498134733a28aae066201993d | pl_pl | 2013-09-15T12:34:09.192Z | e5d4b884d3f24c54a47162af74a1ad09 | 0 | A | 3 | 2 | 1 |
| 84948 | 19208 | 2 | 0 | FCO | 8300743 | 0 | 2 | PL | WAW | PLN | 2 | 95582540167d4ebb9497a7031f046757 | 9 | website | 2 | RT | 1 | economy | FCO | bf4837e7d7b041f2a583783bbe866436 | 6672512 | 823 | 1 | WAW | SH | 05aa66ad90564e9caf593f69bf0df44c | a03320192e4e4a66bf8ea324c8d6b7f5 | 6999715 | 1495000 | 0 | 18 | Europe/Rome | 15 | 9 | Europe/Warsaw | FCO | IT | 2 | 0 | 71 | 1 | 1 | WAW | PL | -9999 | 815e167f6e56449e90d6fc13826cb361 | pl_pl | 2013-10-01T09:07:56.159Z | 195a4dc345f4494aa474aca7f271d556 | 0 | B | 4 | 3 | 5 |